1 <?xml version="1.0" encoding="utf-8"?>
2 <xs:schema id="SIS_DBDataSet" targetNamespace="http://tempuri.org/SIS_DBDataSet.xsd" xmlns:mstns="http://tempuri.org/SIS_DBDataSet.xsd" xmlns="http://tempuri.org/SIS_DBDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
3 <xs:annotation>
4 <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
5 <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
6 <Connections>
7 <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="SIS_DBConnectionString1" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="SIS_DBConnectionString1 (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Sales_and_Inventory_System.My.MySettings.GlobalReference.Default.SIS_DBConnectionString1" Provider="System.Data.SqlClient" />
8 </Connections>
9 <Tables>
10 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ActivationTableAdapter" GeneratorDataComponentClassName="ActivationTableAdapter" Name="Activation" UserDataComponentName="ActivationTableAdapter">
11 <MainSource>
12 <DbSource ConnectionRef="SIS_DBConnectionString1 (MySettings)" DbObjectName="SIS_DB.dbo.Activation" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
13 <DeleteCommand>
14 <DbCommand CommandType="Text" ModifiedByUser="false">
15 <CommandText>DELETE FROM [dbo].[Activation] WHERE (([ID] = @Original_ID) AND ([HardwareID] = @Original_HardwareID) AND ([SerialNo] = @Original_SerialNo) AND ([ActivationID] = @Original_ActivationID))</CommandText>
16 <Parameters>
17 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
18 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_HardwareID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="HardwareID" SourceColumnNullMapping="false" SourceVersion="Original" />
19 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_SerialNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="SerialNo" SourceColumnNullMapping="false" SourceVersion="Original" />
20 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ActivationID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ActivationID" SourceColumnNullMapping="false" SourceVersion="Original" />
21 </Parameters>
22 </DbCommand>
23 </DeleteCommand>
24 <InsertCommand>
25 <DbCommand CommandType="Text" ModifiedByUser="false">
26 <CommandText>INSERT INTO [dbo].[Activation] ([HardwareID], [SerialNo], [ActivationID]) VALUES (@HardwareID, @SerialNo, @ActivationID);
27 SELECT ID, HardwareID, SerialNo, ActivationID FROM Activation WHERE (ID = SCOPE_IDENTITY())</CommandText>
28 <Parameters>
29 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@HardwareID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="HardwareID" SourceColumnNullMapping="false" SourceVersion="Current" />
30 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@SerialNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="SerialNo" SourceColumnNullMapping="false" SourceVersion="Current" />
31 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ActivationID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ActivationID" SourceColumnNullMapping="false" SourceVersion="Current" />
32 </Parameters>
33 </DbCommand>
34 </InsertCommand>
35 <SelectCommand>
36 <DbCommand CommandType="Text" ModifiedByUser="false">
37 <CommandText>SELECT ID, HardwareID, SerialNo, ActivationID FROM dbo.Activation</CommandText>
38 <Parameters />
39 </DbCommand>
40 </SelectCommand>
41 <UpdateCommand>
42 <DbCommand CommandType="Text" ModifiedByUser="false">
43 <CommandText>UPDATE [dbo].[Activation] SET [HardwareID] = @HardwareID, [SerialNo] = @SerialNo, [ActivationID] = @ActivationID WHERE (([ID] = @Original_ID) AND ([HardwareID] = @Original_HardwareID) AND ([SerialNo] = @Original_SerialNo) AND ([ActivationID] = @Original_ActivationID));
44 SELECT ID, HardwareID, SerialNo, ActivationID FROM Activation WHERE (ID = @ID)</CommandText>
45 <Parameters>
46 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@HardwareID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="HardwareID" SourceColumnNullMapping="false" SourceVersion="Current" />
47 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@SerialNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="SerialNo" SourceColumnNullMapping="false" SourceVersion="Current" />
48 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ActivationID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ActivationID" SourceColumnNullMapping="false" SourceVersion="Current" />
49 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
50 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_HardwareID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="HardwareID" SourceColumnNullMapping="false" SourceVersion="Original" />
51 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_SerialNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="SerialNo" SourceColumnNullMapping="false" SourceVersion="Original" />
52 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ActivationID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ActivationID" SourceColumnNullMapping="false" SourceVersion="Original" />
53 <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="SIS_DB.dbo.Activation" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
54 </Parameters>
55 </DbCommand>
56 </UpdateCommand>
57 </DbSource>
58 </MainSource>
59 <Mappings>
60 <Mapping SourceColumn="ID" DataSetColumn="ID" />
61 <Mapping SourceColumn="HardwareID" DataSetColumn="HardwareID" />
62 <Mapping SourceColumn="SerialNo" DataSetColumn="SerialNo" />
63 <Mapping SourceColumn="ActivationID" DataSetColumn="ActivationID" />
64 </Mappings>
65 <Sources />
66 </TableAdapter>
67 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CategoryTableAdapter" GeneratorDataComponentClassName="CategoryTableAdapter" Name="Category" UserDataComponentName="CategoryTableAdapter">
68 <MainSource>
69 <DbSource ConnectionRef="SIS_DBConnectionString1 (MySettings)" DbObjectName="SIS_DB.dbo.Category" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
70 <DeleteCommand>
71 <DbCommand CommandType="Text" ModifiedByUser="false">
72 <CommandText>DELETE FROM [dbo].[Category] WHERE (([CategoryName] = @Original_CategoryName))</CommandText>
73 <Parameters>
74 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_CategoryName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CategoryName" SourceColumnNullMapping="false" SourceVersion="Original" />
75 </Parameters>
76 </DbCommand>
77 </DeleteCommand>
78 <InsertCommand>
79 <DbCommand CommandType="Text" ModifiedByUser="false">
80 <CommandText>INSERT INTO [dbo].[Category] ([CategoryName]) VALUES (@CategoryName);
81 SELECT CategoryName FROM Category WHERE (CategoryName = @CategoryName)</CommandText>
82 <Parameters>
83 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@CategoryName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CategoryName" SourceColumnNullMapping="false" SourceVersion="Current" />
84 </Parameters>
85 </DbCommand>
86 </InsertCommand>
87 <SelectCommand>
88 <DbCommand CommandType="Text" ModifiedByUser="false">
89 <CommandText>SELECT CategoryName FROM dbo.Category</CommandText>
90 <Parameters />
91 </DbCommand>
92 </SelectCommand>
93 <UpdateCommand>
94 <DbCommand CommandType="Text" ModifiedByUser="false">
95 <CommandText>UPDATE [dbo].[Category] SET [CategoryName] = @CategoryName WHERE (([CategoryName] = @Original_CategoryName));
96 SELECT CategoryName FROM Category WHERE (CategoryName = @CategoryName)</CommandText>
97 <Parameters>
98 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@CategoryName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CategoryName" SourceColumnNullMapping="false" SourceVersion="Current" />
99 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_CategoryName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CategoryName" SourceColumnNullMapping="false" SourceVersion="Original" />
100 </Parameters>
101 </DbCommand>
102 </UpdateCommand>
103 </DbSource>
104 </MainSource>
105 <Mappings>
106 <Mapping SourceColumn="CategoryName" DataSetColumn="CategoryName" />
107 </Mappings>
108 <Sources />
109 </TableAdapter>
110 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CompanyTableAdapter" GeneratorDataComponentClassName="CompanyTableAdapter" Name="Company" UserDataComponentName="CompanyTableAdapter">
111 <MainSource>
112 <DbSource ConnectionRef="SIS_DBConnectionString1 (MySettings)" DbObjectName="SIS_DB.dbo.Company" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
113 <DeleteCommand>
114 <DbCommand CommandType="Text" ModifiedByUser="false">
115 <CommandText>DELETE FROM [dbo].[Company] WHERE (([ID] = @Original_ID) AND ([CompanyName] = @Original_CompanyName) AND ([Address] = @Original_Address) AND ([ContactNo] = @Original_ContactNo) AND ([EmailID] = @Original_EmailID) AND ((@IsNull_TIN = 1 AND [TIN] IS NULL) OR ([TIN] = @Original_TIN)) AND ((@IsNull_STNo = 1 AND [STNo] IS NULL) OR ([STNo] = @Original_STNo)) AND ((@IsNull_CIN = 1 AND [CIN] IS NULL) OR ([CIN] = @Original_CIN)))</CommandText>
116 <Parameters>
117 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
118 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_CompanyName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CompanyName" SourceColumnNullMapping="false" SourceVersion="Original" />
119 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Original" />
120 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Original" />
121 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_EmailID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmailID" SourceColumnNullMapping="false" SourceVersion="Original" />
122 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TIN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TIN" SourceColumnNullMapping="true" SourceVersion="Original" />
123 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_TIN" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="TIN" SourceColumnNullMapping="false" SourceVersion="Original" />
124 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_STNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="STNo" SourceColumnNullMapping="true" SourceVersion="Original" />
125 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_STNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="STNo" SourceColumnNullMapping="false" SourceVersion="Original" />
126 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CIN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CIN" SourceColumnNullMapping="true" SourceVersion="Original" />
127 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_CIN" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CIN" SourceColumnNullMapping="false" SourceVersion="Original" />
128 </Parameters>
129 </DbCommand>
130 </DeleteCommand>
131 <InsertCommand>
132 <DbCommand CommandType="Text" ModifiedByUser="false">
133 <CommandText>INSERT INTO [dbo].[Company] ([CompanyName], [Address], [ContactNo], [EmailID], [Logo], [TIN], [STNo], [CIN]) VALUES (@CompanyName, @Address, @ContactNo, @EmailID, @Logo, @TIN, @STNo, @CIN);
134 SELECT ID, CompanyName, Address, ContactNo, EmailID, Logo, TIN, STNo, CIN FROM Company WHERE (ID = SCOPE_IDENTITY())</CommandText>
135 <Parameters>
136 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@CompanyName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CompanyName" SourceColumnNullMapping="false" SourceVersion="Current" />
137 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
138 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Current" />
139 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EmailID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmailID" SourceColumnNullMapping="false" SourceVersion="Current" />
140 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Logo" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Logo" SourceColumnNullMapping="false" SourceVersion="Current" />
141 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@TIN" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="TIN" SourceColumnNullMapping="false" SourceVersion="Current" />
142 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@STNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="STNo" SourceColumnNullMapping="false" SourceVersion="Current" />
143 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@CIN" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CIN" SourceColumnNullMapping="false" SourceVersion="Current" />
144 </Parameters>
145 </DbCommand>
146 </InsertCommand>
147 <SelectCommand>
148 <DbCommand CommandType="Text" ModifiedByUser="false">
149 <CommandText>SELECT ID, CompanyName, Address, ContactNo, EmailID, Logo, TIN, STNo, CIN FROM dbo.Company</CommandText>
150 <Parameters />
151 </DbCommand>
152 </SelectCommand>
153 <UpdateCommand>
154 <DbCommand CommandType="Text" ModifiedByUser="false">
155 <CommandText>UPDATE [dbo].[Company] SET [CompanyName] = @CompanyName, [Address] = @Address, [ContactNo] = @ContactNo, [EmailID] = @EmailID, [Logo] = @Logo, [TIN] = @TIN, [STNo] = @STNo, [CIN] = @CIN WHERE (([ID] = @Original_ID) AND ([CompanyName] = @Original_CompanyName) AND ([Address] = @Original_Address) AND ([ContactNo] = @Original_ContactNo) AND ([EmailID] = @Original_EmailID) AND ((@IsNull_TIN = 1 AND [TIN] IS NULL) OR ([TIN] = @Original_TIN)) AND ((@IsNull_STNo = 1 AND [STNo] IS NULL) OR ([STNo] = @Original_STNo)) AND ((@IsNull_CIN = 1 AND [CIN] IS NULL) OR ([CIN] = @Original_CIN)));
156 SELECT ID, CompanyName, Address, ContactNo, EmailID, Logo, TIN, STNo, CIN FROM Company WHERE (ID = @ID)</CommandText>
157 <Parameters>
158 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@CompanyName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CompanyName" SourceColumnNullMapping="false" SourceVersion="Current" />
159 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
160 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Current" />
161 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EmailID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmailID" SourceColumnNullMapping="false" SourceVersion="Current" />
162 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Logo" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Logo" SourceColumnNullMapping="false" SourceVersion="Current" />
163 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@TIN" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="TIN" SourceColumnNullMapping="false" SourceVersion="Current" />
164 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@STNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="STNo" SourceColumnNullMapping="false" SourceVersion="Current" />
165 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@CIN" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CIN" SourceColumnNullMapping="false" SourceVersion="Current" />
166 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
167 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_CompanyName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CompanyName" SourceColumnNullMapping="false" SourceVersion="Original" />
168 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Original" />
169 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Original" />
170 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_EmailID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmailID" SourceColumnNullMapping="false" SourceVersion="Original" />
171 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TIN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TIN" SourceColumnNullMapping="true" SourceVersion="Original" />
172 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_TIN" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="TIN" SourceColumnNullMapping="false" SourceVersion="Original" />
173 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_STNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="STNo" SourceColumnNullMapping="true" SourceVersion="Original" />
174 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_STNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="STNo" SourceColumnNullMapping="false" SourceVersion="Original" />
175 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CIN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CIN" SourceColumnNullMapping="true" SourceVersion="Original" />
176 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_CIN" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CIN" SourceColumnNullMapping="false" SourceVersion="Original" />
177 <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="SIS_DB.dbo.Company" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
178 </Parameters>
179 </DbCommand>
180 </UpdateCommand>
181 </DbSource>
182 </MainSource>
183 <Mappings>
184 <Mapping SourceColumn="ID" DataSetColumn="ID" />
185 <Mapping SourceColumn="CompanyName" DataSetColumn="CompanyName" />
186 <Mapping SourceColumn="Address" DataSetColumn="Address" />
187 <Mapping SourceColumn="ContactNo" DataSetColumn="ContactNo" />
188 <Mapping SourceColumn="EmailID" DataSetColumn="EmailID" />
189 <Mapping SourceColumn="Logo" DataSetColumn="Logo" />
190 <Mapping SourceColumn="TIN" DataSetColumn="TIN" />
191 <Mapping SourceColumn="STNo" DataSetColumn="STNo" />
192 <Mapping SourceColumn="CIN" DataSetColumn="CIN" />
193 </Mappings>
194 <Sources />
195 </TableAdapter>
196 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Company_ContactsTableAdapter" GeneratorDataComponentClassName="Company_ContactsTableAdapter" Name="Company_Contacts" UserDataComponentName="Company_ContactsTableAdapter">
197 <MainSource>
198 <DbSource ConnectionRef="SIS_DBConnectionString1 (MySettings)" DbObjectName="SIS_DB.dbo.Company_Contacts" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
199 <DeleteCommand>
200 <DbCommand CommandType="Text" ModifiedByUser="false">
201 <CommandText>DELETE FROM [dbo].[Company_Contacts] WHERE (([Id] = @Original_Id) AND ([ContactPerson] = @Original_ContactPerson) AND ([ContactNo] = @Original_ContactNo))</CommandText>
202 <Parameters>
203 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
204 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ContactPerson" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactPerson" SourceColumnNullMapping="false" SourceVersion="Original" />
205 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Original" />
206 </Parameters>
207 </DbCommand>
208 </DeleteCommand>
209 <InsertCommand>
210 <DbCommand CommandType="Text" ModifiedByUser="false">
211 <CommandText>INSERT INTO [dbo].[Company_Contacts] ([ContactPerson], [ContactNo]) VALUES (@ContactPerson, @ContactNo);
212 SELECT Id, ContactPerson, ContactNo FROM Company_Contacts WHERE (Id = SCOPE_IDENTITY())</CommandText>
213 <Parameters>
214 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ContactPerson" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactPerson" SourceColumnNullMapping="false" SourceVersion="Current" />
215 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Current" />
216 </Parameters>
217 </DbCommand>
218 </InsertCommand>
219 <SelectCommand>
220 <DbCommand CommandType="Text" ModifiedByUser="false">
221 <CommandText>SELECT Id, ContactPerson, ContactNo FROM dbo.Company_Contacts</CommandText>
222 <Parameters />
223 </DbCommand>
224 </SelectCommand>
225 <UpdateCommand>
226 <DbCommand CommandType="Text" ModifiedByUser="false">
227 <CommandText>UPDATE [dbo].[Company_Contacts] SET [ContactPerson] = @ContactPerson, [ContactNo] = @ContactNo WHERE (([Id] = @Original_Id) AND ([ContactPerson] = @Original_ContactPerson) AND ([ContactNo] = @Original_ContactNo));
228 SELECT Id, ContactPerson, ContactNo FROM Company_Contacts WHERE (Id = @Id)</CommandText>
229 <Parameters>
230 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ContactPerson" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactPerson" SourceColumnNullMapping="false" SourceVersion="Current" />
231 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Current" />
232 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
233 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ContactPerson" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactPerson" SourceColumnNullMapping="false" SourceVersion="Original" />
234 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Original" />
235 <Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="Id" DataSourceName="SIS_DB.dbo.Company_Contacts" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
236 </Parameters>
237 </DbCommand>
238 </UpdateCommand>
239 </DbSource>
240 </MainSource>
241 <Mappings>
242 <Mapping SourceColumn="Id" DataSetColumn="Id" />
243 <Mapping SourceColumn="ContactPerson" DataSetColumn="ContactPerson" />
244 <Mapping SourceColumn="ContactNo" DataSetColumn="ContactNo" />
245 </Mappings>
246 <Sources />
247 </TableAdapter>
248 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CustomerTableAdapter" GeneratorDataComponentClassName="CustomerTableAdapter" Name="Customer" UserDataComponentName="CustomerTableAdapter">
249 <MainSource>
250 <DbSource ConnectionRef="SIS_DBConnectionString1 (MySettings)" DbObjectName="SIS_DB.dbo.Customer" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
251 <DeleteCommand>
252 <DbCommand CommandType="Text" ModifiedByUser="false">
253 <CommandText>DELETE FROM [dbo].[Customer] WHERE (([ID] = @Original_ID) AND ([CustomerID] = @Original_CustomerID) AND ([Name] = @Original_Name) AND ([Gender] = @Original_Gender) AND ([Address] = @Original_Address) AND ([City] = @Original_City) AND ([State] = @Original_State) AND ((@IsNull_ZipCode = 1 AND [ZipCode] IS NULL) OR ([ZipCode] = @Original_ZipCode)) AND ([ContactNo] = @Original_ContactNo) AND ((@IsNull_EmailID = 1 AND [EmailID] IS NULL) OR ([EmailID] = @Original_EmailID)))</CommandText>
254 <Parameters>
255 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
256 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_CustomerID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="false" SourceVersion="Original" />
257 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
258 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Gender" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Gender" SourceColumnNullMapping="false" SourceVersion="Original" />
259 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Original" />
260 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_City" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Original" />
261 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_State" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Original" />
262 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ZipCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ZipCode" SourceColumnNullMapping="true" SourceVersion="Original" />
263 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ZipCode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ZipCode" SourceColumnNullMapping="false" SourceVersion="Original" />
264 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Original" />
265 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmailID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmailID" SourceColumnNullMapping="true" SourceVersion="Original" />
266 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_EmailID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmailID" SourceColumnNullMapping="false" SourceVersion="Original" />
267 </Parameters>
268 </DbCommand>
269 </DeleteCommand>
270 <InsertCommand>
271 <DbCommand CommandType="Text" ModifiedByUser="false">
272 <CommandText>INSERT INTO [dbo].[Customer] ([ID], [CustomerID], [Name], [Gender], [Address], [City], [State], [ZipCode], [ContactNo], [EmailID], [Remarks], [Photo]) VALUES (@ID, @CustomerID, @Name, @Gender, @Address, @City, @State, @ZipCode, @ContactNo, @EmailID, @Remarks, @Photo);
273 SELECT ID, CustomerID, Name, Gender, Address, City, State, ZipCode, ContactNo, EmailID, Remarks, Photo FROM Customer WHERE (ID = @ID)</CommandText>
274 <Parameters>
275 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
276 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@CustomerID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="false" SourceVersion="Current" />
277 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
278 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Gender" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Gender" SourceColumnNullMapping="false" SourceVersion="Current" />
279 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
280 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@City" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Current" />
281 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@State" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Current" />
282 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ZipCode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ZipCode" SourceColumnNullMapping="false" SourceVersion="Current" />
283 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Current" />
284 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EmailID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmailID" SourceColumnNullMapping="false" SourceVersion="Current" />
285 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remarks" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remarks" SourceColumnNullMapping="false" SourceVersion="Current" />
286 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Photo" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Photo" SourceColumnNullMapping="false" SourceVersion="Current" />
287 </Parameters>
288 </DbCommand>
289 </InsertCommand>
290 <SelectCommand>
291 <DbCommand CommandType="Text" ModifiedByUser="false">
292 <CommandText>SELECT ID, CustomerID, Name, Gender, Address, City, State, ZipCode, ContactNo, EmailID, Remarks, Photo FROM dbo.Customer</CommandText>
293 <Parameters />
294 </DbCommand>
295 </SelectCommand>
296 <UpdateCommand>
297 <DbCommand CommandType="Text" ModifiedByUser="false">
298 <CommandText>UPDATE [dbo].[Customer] SET [ID] = @ID, [CustomerID] = @CustomerID, [Name] = @Name, [Gender] = @Gender, [Address] = @Address, [City] = @City, [State] = @State, [ZipCode] = @ZipCode, [ContactNo] = @ContactNo, [EmailID] = @EmailID, [Remarks] = @Remarks, [Photo] = @Photo WHERE (([ID] = @Original_ID) AND ([CustomerID] = @Original_CustomerID) AND ([Name] = @Original_Name) AND ([Gender] = @Original_Gender) AND ([Address] = @Original_Address) AND ([City] = @Original_City) AND ([State] = @Original_State) AND ((@IsNull_ZipCode = 1 AND [ZipCode] IS NULL) OR ([ZipCode] = @Original_ZipCode)) AND ([ContactNo] = @Original_ContactNo) AND ((@IsNull_EmailID = 1 AND [EmailID] IS NULL) OR ([EmailID] = @Original_EmailID)));
299 SELECT ID, CustomerID, Name, Gender, Address, City, State, ZipCode, ContactNo, EmailID, Remarks, Photo FROM Customer WHERE (ID = @ID)</CommandText>
300 <Parameters>
301 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
302 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@CustomerID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="false" SourceVersion="Current" />
303 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
304 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Gender" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Gender" SourceColumnNullMapping="false" SourceVersion="Current" />
305 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
306 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@City" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Current" />
307 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@State" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Current" />
308 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ZipCode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ZipCode" SourceColumnNullMapping="false" SourceVersion="Current" />
309 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Current" />
310 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EmailID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmailID" SourceColumnNullMapping="false" SourceVersion="Current" />
311 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remarks" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remarks" SourceColumnNullMapping="false" SourceVersion="Current" />
312 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Photo" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Photo" SourceColumnNullMapping="false" SourceVersion="Current" />
313 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
314 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_CustomerID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="false" SourceVersion="Original" />
315 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
316 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Gender" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Gender" SourceColumnNullMapping="false" SourceVersion="Original" />
317 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Original" />
318 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_City" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Original" />
319 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_State" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Original" />
320 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ZipCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ZipCode" SourceColumnNullMapping="true" SourceVersion="Original" />
321 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ZipCode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ZipCode" SourceColumnNullMapping="false" SourceVersion="Original" />
322 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Original" />
323 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmailID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmailID" SourceColumnNullMapping="true" SourceVersion="Original" />
324 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_EmailID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmailID" SourceColumnNullMapping="false" SourceVersion="Original" />
325 </Parameters>
326 </DbCommand>
327 </UpdateCommand>
328 </DbSource>
329 </MainSource>
330 <Mappings>
331 <Mapping SourceColumn="ID" DataSetColumn="ID" />
332 <Mapping SourceColumn="CustomerID" DataSetColumn="CustomerID" />
333 <Mapping SourceColumn="Name" DataSetColumn="Name" />
334 <Mapping SourceColumn="Gender" DataSetColumn="Gender" />
335 <Mapping SourceColumn="Address" DataSetColumn="Address" />
336 <Mapping SourceColumn="City" DataSetColumn="City" />
337 <Mapping SourceColumn="State" DataSetColumn="State" />
338 <Mapping SourceColumn="ZipCode" DataSetColumn="ZipCode" />
339 <Mapping SourceColumn="ContactNo" DataSetColumn="ContactNo" />
340 <Mapping SourceColumn="EmailID" DataSetColumn="EmailID" />
341 <Mapping SourceColumn="Remarks" DataSetColumn="Remarks" />
342 <Mapping SourceColumn="Photo" DataSetColumn="Photo" />
343 </Mappings>
344 <Sources />
345 </TableAdapter>
346 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Invoice_PaymentTableAdapter" GeneratorDataComponentClassName="Invoice_PaymentTableAdapter" Name="Invoice_Payment" UserDataComponentName="Invoice_PaymentTableAdapter">
347 <MainSource>
348 <DbSource ConnectionRef="SIS_DBConnectionString1 (MySettings)" DbObjectName="SIS_DB.dbo.Invoice_Payment" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
349 <DeleteCommand>
350 <DbCommand CommandType="Text" ModifiedByUser="false">
351 <CommandText>DELETE FROM [dbo].[Invoice_Payment] WHERE (([IP_ID] = @Original_IP_ID) AND ([InvoiceID] = @Original_InvoiceID) AND ([PaymentDate] = @Original_PaymentDate) AND ([TotalPaid] = @Original_TotalPaid) AND ([PaymentMode] = @Original_PaymentMode))</CommandText>
352 <Parameters>
353 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IP_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IP_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
354 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_InvoiceID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InvoiceID" SourceColumnNullMapping="false" SourceVersion="Original" />
355 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_PaymentDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="PaymentDate" SourceColumnNullMapping="false" SourceVersion="Original" />
356 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TotalPaid" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalPaid" SourceColumnNullMapping="false" SourceVersion="Original" />
357 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_PaymentMode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="PaymentMode" SourceColumnNullMapping="false" SourceVersion="Original" />
358 </Parameters>
359 </DbCommand>
360 </DeleteCommand>
361 <InsertCommand>
362 <DbCommand CommandType="Text" ModifiedByUser="false">
363 <CommandText>INSERT INTO [dbo].[Invoice_Payment] ([InvoiceID], [PaymentDate], [TotalPaid], [PaymentMode]) VALUES (@InvoiceID, @PaymentDate, @TotalPaid, @PaymentMode);
364 SELECT IP_ID, InvoiceID, PaymentDate, TotalPaid, PaymentMode FROM Invoice_Payment WHERE (IP_ID = SCOPE_IDENTITY())</CommandText>
365 <Parameters>
366 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@InvoiceID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InvoiceID" SourceColumnNullMapping="false" SourceVersion="Current" />
367 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@PaymentDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="PaymentDate" SourceColumnNullMapping="false" SourceVersion="Current" />
368 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TotalPaid" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalPaid" SourceColumnNullMapping="false" SourceVersion="Current" />
369 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@PaymentMode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="PaymentMode" SourceColumnNullMapping="false" SourceVersion="Current" />
370 </Parameters>
371 </DbCommand>
372 </InsertCommand>
373 <SelectCommand>
374 <DbCommand CommandType="Text" ModifiedByUser="false">
375 <CommandText>SELECT IP_ID, InvoiceID, PaymentDate, TotalPaid, PaymentMode FROM dbo.Invoice_Payment</CommandText>
376 <Parameters />
377 </DbCommand>
378 </SelectCommand>
379 <UpdateCommand>
380 <DbCommand CommandType="Text" ModifiedByUser="false">
381 <CommandText>UPDATE [dbo].[Invoice_Payment] SET [InvoiceID] = @InvoiceID, [PaymentDate] = @PaymentDate, [TotalPaid] = @TotalPaid, [PaymentMode] = @PaymentMode WHERE (([IP_ID] = @Original_IP_ID) AND ([InvoiceID] = @Original_InvoiceID) AND ([PaymentDate] = @Original_PaymentDate) AND ([TotalPaid] = @Original_TotalPaid) AND ([PaymentMode] = @Original_PaymentMode));
382 SELECT IP_ID, InvoiceID, PaymentDate, TotalPaid, PaymentMode FROM Invoice_Payment WHERE (IP_ID = @IP_ID)</CommandText>
383 <Parameters>
384 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@InvoiceID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InvoiceID" SourceColumnNullMapping="false" SourceVersion="Current" />
385 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@PaymentDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="PaymentDate" SourceColumnNullMapping="false" SourceVersion="Current" />
386 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TotalPaid" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalPaid" SourceColumnNullMapping="false" SourceVersion="Current" />
387 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@PaymentMode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="PaymentMode" SourceColumnNullMapping="false" SourceVersion="Current" />
388 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IP_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IP_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
389 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_InvoiceID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InvoiceID" SourceColumnNullMapping="false" SourceVersion="Original" />
390 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_PaymentDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="PaymentDate" SourceColumnNullMapping="false" SourceVersion="Original" />
391 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TotalPaid" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalPaid" SourceColumnNullMapping="false" SourceVersion="Original" />
392 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_PaymentMode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="PaymentMode" SourceColumnNullMapping="false" SourceVersion="Original" />
393 <Parameter AllowDbNull="false" AutogeneratedName="IP_ID" ColumnName="IP_ID" DataSourceName="SIS_DB.dbo.Invoice_Payment" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IP_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IP_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
394 </Parameters>
395 </DbCommand>
396 </UpdateCommand>
397 </DbSource>
398 </MainSource>
399 <Mappings>
400 <Mapping SourceColumn="IP_ID" DataSetColumn="IP_ID" />
401 <Mapping SourceColumn="InvoiceID" DataSetColumn="InvoiceID" />
402 <Mapping SourceColumn="PaymentDate" DataSetColumn="PaymentDate" />
403 <Mapping SourceColumn="TotalPaid" DataSetColumn="TotalPaid" />
404 <Mapping SourceColumn="PaymentMode" DataSetColumn="PaymentMode" />
405 </Mappings>
406 <Sources />
407 </TableAdapter>
408 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Invoice_ProductTableAdapter" GeneratorDataComponentClassName="Invoice_ProductTableAdapter" Name="Invoice_Product" UserDataComponentName="Invoice_ProductTableAdapter">
409 <MainSource>
410 <DbSource ConnectionRef="SIS_DBConnectionString1 (MySettings)" DbObjectName="SIS_DB.dbo.Invoice_Product" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
411 <DeleteCommand>
412 <DbCommand CommandType="Text" ModifiedByUser="false">
413 <CommandText>DELETE FROM [dbo].[Invoice_Product] WHERE (([IPo_ID] = @Original_IPo_ID) AND ([InvoiceID] = @Original_InvoiceID) AND ([ProductID] = @Original_ProductID) AND ([CostPrice] = @Original_CostPrice) AND ([SellingPrice] = @Original_SellingPrice) AND ([Margin] = @Original_Margin) AND ([Qty] = @Original_Qty) AND ([Amount] = @Original_Amount) AND ([DiscountPer] = @Original_DiscountPer) AND ([Discount] = @Original_Discount) AND ([VATPer] = @Original_VATPer) AND ([VAT] = @Original_VAT) AND ([TotalAmount] = @Original_TotalAmount))</CommandText>
414 <Parameters>
415 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IPo_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IPo_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
416 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_InvoiceID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InvoiceID" SourceColumnNullMapping="false" SourceVersion="Original" />
417 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
418 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_CostPrice" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CostPrice" SourceColumnNullMapping="false" SourceVersion="Original" />
419 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_SellingPrice" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="SellingPrice" SourceColumnNullMapping="false" SourceVersion="Original" />
420 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Margin" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Margin" SourceColumnNullMapping="false" SourceVersion="Original" />
421 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Qty" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Qty" SourceColumnNullMapping="false" SourceVersion="Original" />
422 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Amount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Amount" SourceColumnNullMapping="false" SourceVersion="Original" />
423 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_DiscountPer" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DiscountPer" SourceColumnNullMapping="false" SourceVersion="Original" />
424 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Discount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Discount" SourceColumnNullMapping="false" SourceVersion="Original" />
425 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_VATPer" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="VATPer" SourceColumnNullMapping="false" SourceVersion="Original" />
426 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_VAT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="VAT" SourceColumnNullMapping="false" SourceVersion="Original" />
427 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TotalAmount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalAmount" SourceColumnNullMapping="false" SourceVersion="Original" />
428 </Parameters>
429 </DbCommand>
430 </DeleteCommand>
431 <InsertCommand>
432 <DbCommand CommandType="Text" ModifiedByUser="false">
433 <CommandText>INSERT INTO [dbo].[Invoice_Product] ([InvoiceID], [ProductID], [CostPrice], [SellingPrice], [Margin], [Qty], [Amount], [DiscountPer], [Discount], [VATPer], [VAT], [TotalAmount]) VALUES (@InvoiceID, @ProductID, @CostPrice, @SellingPrice, @Margin, @Qty, @Amount, @DiscountPer, @Discount, @VATPer, @VAT, @TotalAmount);
434 SELECT IPo_ID, InvoiceID, ProductID, CostPrice, SellingPrice, Margin, Qty, Amount, DiscountPer, Discount, VATPer, VAT, TotalAmount FROM Invoice_Product WHERE (IPo_ID = SCOPE_IDENTITY())</CommandText>
435 <Parameters>
436 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@InvoiceID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InvoiceID" SourceColumnNullMapping="false" SourceVersion="Current" />
437 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
438 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CostPrice" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CostPrice" SourceColumnNullMapping="false" SourceVersion="Current" />
439 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@SellingPrice" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="SellingPrice" SourceColumnNullMapping="false" SourceVersion="Current" />
440 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Margin" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Margin" SourceColumnNullMapping="false" SourceVersion="Current" />
441 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Qty" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Qty" SourceColumnNullMapping="false" SourceVersion="Current" />
442 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Amount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Amount" SourceColumnNullMapping="false" SourceVersion="Current" />
443 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@DiscountPer" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DiscountPer" SourceColumnNullMapping="false" SourceVersion="Current" />
444 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Discount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Discount" SourceColumnNullMapping="false" SourceVersion="Current" />
445 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@VATPer" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="VATPer" SourceColumnNullMapping="false" SourceVersion="Current" />
446 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@VAT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="VAT" SourceColumnNullMapping="false" SourceVersion="Current" />
447 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TotalAmount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalAmount" SourceColumnNullMapping="false" SourceVersion="Current" />
448 </Parameters>
449 </DbCommand>
450 </InsertCommand>
451 <SelectCommand>
452 <DbCommand CommandType="Text" ModifiedByUser="false">
453 <CommandText>SELECT IPo_ID, InvoiceID, ProductID, CostPrice, SellingPrice, Margin, Qty, Amount, DiscountPer, Discount, VATPer, VAT, TotalAmount FROM dbo.Invoice_Product</CommandText>
454 <Parameters />
455 </DbCommand>
456 </SelectCommand>
457 <UpdateCommand>
458 <DbCommand CommandType="Text" ModifiedByUser="false">
459 <CommandText>UPDATE [dbo].[Invoice_Product] SET [InvoiceID] = @InvoiceID, [ProductID] = @ProductID, [CostPrice] = @CostPrice, [SellingPrice] = @SellingPrice, [Margin] = @Margin, [Qty] = @Qty, [Amount] = @Amount, [DiscountPer] = @DiscountPer, [Discount] = @Discount, [VATPer] = @VATPer, [VAT] = @VAT, [TotalAmount] = @TotalAmount WHERE (([IPo_ID] = @Original_IPo_ID) AND ([InvoiceID] = @Original_InvoiceID) AND ([ProductID] = @Original_ProductID) AND ([CostPrice] = @Original_CostPrice) AND ([SellingPrice] = @Original_SellingPrice) AND ([Margin] = @Original_Margin) AND ([Qty] = @Original_Qty) AND ([Amount] = @Original_Amount) AND ([DiscountPer] = @Original_DiscountPer) AND ([Discount] = @Original_Discount) AND ([VATPer] = @Original_VATPer) AND ([VAT] = @Original_VAT) AND ([TotalAmount] = @Original_TotalAmount));
460 SELECT IPo_ID, InvoiceID, ProductID, CostPrice, SellingPrice, Margin, Qty, Amount, DiscountPer, Discount, VATPer, VAT, TotalAmount FROM Invoice_Product WHERE (IPo_ID = @IPo_ID)</CommandText>
461 <Parameters>
462 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@InvoiceID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InvoiceID" SourceColumnNullMapping="false" SourceVersion="Current" />
463 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
464 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CostPrice" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CostPrice" SourceColumnNullMapping="false" SourceVersion="Current" />
465 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@SellingPrice" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="SellingPrice" SourceColumnNullMapping="false" SourceVersion="Current" />
466 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Margin" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Margin" SourceColumnNullMapping="false" SourceVersion="Current" />
467 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Qty" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Qty" SourceColumnNullMapping="false" SourceVersion="Current" />
468 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Amount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Amount" SourceColumnNullMapping="false" SourceVersion="Current" />
469 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@DiscountPer" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DiscountPer" SourceColumnNullMapping="false" SourceVersion="Current" />
470 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Discount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Discount" SourceColumnNullMapping="false" SourceVersion="Current" />
471 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@VATPer" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="VATPer" SourceColumnNullMapping="false" SourceVersion="Current" />
472 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@VAT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="VAT" SourceColumnNullMapping="false" SourceVersion="Current" />
473 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TotalAmount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalAmount" SourceColumnNullMapping="false" SourceVersion="Current" />
474 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IPo_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IPo_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
475 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_InvoiceID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InvoiceID" SourceColumnNullMapping="false" SourceVersion="Original" />
476 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
477 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_CostPrice" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CostPrice" SourceColumnNullMapping="false" SourceVersion="Original" />
478 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_SellingPrice" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="SellingPrice" SourceColumnNullMapping="false" SourceVersion="Original" />
479 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Margin" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Margin" SourceColumnNullMapping="false" SourceVersion="Original" />
480 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Qty" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Qty" SourceColumnNullMapping="false" SourceVersion="Original" />
481 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Amount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Amount" SourceColumnNullMapping="false" SourceVersion="Original" />
482 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_DiscountPer" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DiscountPer" SourceColumnNullMapping="false" SourceVersion="Original" />
483 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Discount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Discount" SourceColumnNullMapping="false" SourceVersion="Original" />
484 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_VATPer" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="VATPer" SourceColumnNullMapping="false" SourceVersion="Original" />
485 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_VAT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="VAT" SourceColumnNullMapping="false" SourceVersion="Original" />
486 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TotalAmount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalAmount" SourceColumnNullMapping="false" SourceVersion="Original" />
487 <Parameter AllowDbNull="false" AutogeneratedName="IPo_ID" ColumnName="IPo_ID" DataSourceName="SIS_DB.dbo.Invoice_Product" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IPo_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IPo_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
488 </Parameters>
489 </DbCommand>
490 </UpdateCommand>
491 </DbSource>
492 </MainSource>
493 <Mappings>
494 <Mapping SourceColumn="IPo_ID" DataSetColumn="IPo_ID" />
495 <Mapping SourceColumn="InvoiceID" DataSetColumn="InvoiceID" />
496 <Mapping SourceColumn="ProductID" DataSetColumn="ProductID" />
497 <Mapping SourceColumn="CostPrice" DataSetColumn="CostPrice" />
498 <Mapping SourceColumn="SellingPrice" DataSetColumn="SellingPrice" />
499 <Mapping SourceColumn="Margin" DataSetColumn="Margin" />
500 <Mapping SourceColumn="Qty" DataSetColumn="Qty" />
501 <Mapping SourceColumn="Amount" DataSetColumn="Amount" />
502 <Mapping SourceColumn="DiscountPer" DataSetColumn="DiscountPer" />
503 <Mapping SourceColumn="Discount" DataSetColumn="Discount" />
504 <Mapping SourceColumn="VATPer" DataSetColumn="VATPer" />
505 <Mapping SourceColumn="VAT" DataSetColumn="VAT" />
506 <Mapping SourceColumn="TotalAmount" DataSetColumn="TotalAmount" />
507 </Mappings>
508 <Sources />
509 </TableAdapter>
510 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="InvoiceInfoTableAdapter" GeneratorDataComponentClassName="InvoiceInfoTableAdapter" Name="InvoiceInfo" UserDataComponentName="InvoiceInfoTableAdapter">
511 <MainSource>
512 <DbSource ConnectionRef="SIS_DBConnectionString1 (MySettings)" DbObjectName="SIS_DB.dbo.InvoiceInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
513 <DeleteCommand>
514 <DbCommand CommandType="Text" ModifiedByUser="false">
515 <CommandText>DELETE FROM [dbo].[InvoiceInfo] WHERE (([Inv_ID] = @Original_Inv_ID) AND ([InvoiceNo] = @Original_InvoiceNo) AND ([InvoiceDate] = @Original_InvoiceDate) AND ([CustomerID] = @Original_CustomerID) AND ([GrandTotal] = @Original_GrandTotal) AND ([TotalPaid] = @Original_TotalPaid) AND ([Balance] = @Original_Balance))</CommandText>
516 <Parameters>
517 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Inv_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Inv_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
518 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_InvoiceNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="InvoiceNo" SourceColumnNullMapping="false" SourceVersion="Original" />
519 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_InvoiceDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="InvoiceDate" SourceColumnNullMapping="false" SourceVersion="Original" />
520 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CustomerID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="false" SourceVersion="Original" />
521 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_GrandTotal" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="GrandTotal" SourceColumnNullMapping="false" SourceVersion="Original" />
522 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TotalPaid" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalPaid" SourceColumnNullMapping="false" SourceVersion="Original" />
523 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Balance" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Balance" SourceColumnNullMapping="false" SourceVersion="Original" />
524 </Parameters>
525 </DbCommand>
526 </DeleteCommand>
527 <InsertCommand>
528 <DbCommand CommandType="Text" ModifiedByUser="false">
529 <CommandText>INSERT INTO [dbo].[InvoiceInfo] ([Inv_ID], [InvoiceNo], [InvoiceDate], [CustomerID], [GrandTotal], [TotalPaid], [Balance], [Remarks]) VALUES (@Inv_ID, @InvoiceNo, @InvoiceDate, @CustomerID, @GrandTotal, @TotalPaid, @Balance, @Remarks);
530 SELECT Inv_ID, InvoiceNo, InvoiceDate, CustomerID, GrandTotal, TotalPaid, Balance, Remarks FROM InvoiceInfo WHERE (Inv_ID = @Inv_ID)</CommandText>
531 <Parameters>
532 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Inv_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Inv_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
533 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@InvoiceNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="InvoiceNo" SourceColumnNullMapping="false" SourceVersion="Current" />
534 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@InvoiceDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="InvoiceDate" SourceColumnNullMapping="false" SourceVersion="Current" />
535 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CustomerID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="false" SourceVersion="Current" />
536 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@GrandTotal" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="GrandTotal" SourceColumnNullMapping="false" SourceVersion="Current" />
537 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TotalPaid" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalPaid" SourceColumnNullMapping="false" SourceVersion="Current" />
538 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Balance" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Balance" SourceColumnNullMapping="false" SourceVersion="Current" />
539 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remarks" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remarks" SourceColumnNullMapping="false" SourceVersion="Current" />
540 </Parameters>
541 </DbCommand>
542 </InsertCommand>
543 <SelectCommand>
544 <DbCommand CommandType="Text" ModifiedByUser="false">
545 <CommandText>SELECT Inv_ID, InvoiceNo, InvoiceDate, CustomerID, GrandTotal, TotalPaid, Balance, Remarks FROM dbo.InvoiceInfo</CommandText>
546 <Parameters />
547 </DbCommand>
548 </SelectCommand>
549 <UpdateCommand>
550 <DbCommand CommandType="Text" ModifiedByUser="false">
551 <CommandText>UPDATE [dbo].[InvoiceInfo] SET [Inv_ID] = @Inv_ID, [InvoiceNo] = @InvoiceNo, [InvoiceDate] = @InvoiceDate, [CustomerID] = @CustomerID, [GrandTotal] = @GrandTotal, [TotalPaid] = @TotalPaid, [Balance] = @Balance, [Remarks] = @Remarks WHERE (([Inv_ID] = @Original_Inv_ID) AND ([InvoiceNo] = @Original_InvoiceNo) AND ([InvoiceDate] = @Original_InvoiceDate) AND ([CustomerID] = @Original_CustomerID) AND ([GrandTotal] = @Original_GrandTotal) AND ([TotalPaid] = @Original_TotalPaid) AND ([Balance] = @Original_Balance));
552 SELECT Inv_ID, InvoiceNo, InvoiceDate, CustomerID, GrandTotal, TotalPaid, Balance, Remarks FROM InvoiceInfo WHERE (Inv_ID = @Inv_ID)</CommandText>
553 <Parameters>
554 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Inv_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Inv_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
555 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@InvoiceNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="InvoiceNo" SourceColumnNullMapping="false" SourceVersion="Current" />
556 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@InvoiceDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="InvoiceDate" SourceColumnNullMapping="false" SourceVersion="Current" />
557 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CustomerID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="false" SourceVersion="Current" />
558 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@GrandTotal" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="GrandTotal" SourceColumnNullMapping="false" SourceVersion="Current" />
559 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TotalPaid" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalPaid" SourceColumnNullMapping="false" SourceVersion="Current" />
560 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Balance" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Balance" SourceColumnNullMapping="false" SourceVersion="Current" />
561 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remarks" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remarks" SourceColumnNullMapping="false" SourceVersion="Current" />
562 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Inv_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Inv_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
563 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_InvoiceNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="InvoiceNo" SourceColumnNullMapping="false" SourceVersion="Original" />
564 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_InvoiceDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="InvoiceDate" SourceColumnNullMapping="false" SourceVersion="Original" />
565 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CustomerID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="false" SourceVersion="Original" />
566 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_GrandTotal" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="GrandTotal" SourceColumnNullMapping="false" SourceVersion="Original" />
567 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TotalPaid" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalPaid" SourceColumnNullMapping="false" SourceVersion="Original" />
568 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Balance" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Balance" SourceColumnNullMapping="false" SourceVersion="Original" />
569 </Parameters>
570 </DbCommand>
571 </UpdateCommand>
572 </DbSource>
573 </MainSource>
574 <Mappings>
575 <Mapping SourceColumn="Inv_ID" DataSetColumn="Inv_ID" />
576 <Mapping SourceColumn="InvoiceNo" DataSetColumn="InvoiceNo" />
577 <Mapping SourceColumn="InvoiceDate" DataSetColumn="InvoiceDate" />
578 <Mapping SourceColumn="CustomerID" DataSetColumn="CustomerID" />
579 <Mapping SourceColumn="GrandTotal" DataSetColumn="GrandTotal" />
580 <Mapping SourceColumn="TotalPaid" DataSetColumn="TotalPaid" />
581 <Mapping SourceColumn="Balance" DataSetColumn="Balance" />
582 <Mapping SourceColumn="Remarks" DataSetColumn="Remarks" />
583 </Mappings>
584 <Sources />
585 </TableAdapter>
586 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LogsTableAdapter" GeneratorDataComponentClassName="LogsTableAdapter" Name="Logs" UserDataComponentName="LogsTableAdapter">
587 <MainSource>
588 <DbSource ConnectionRef="SIS_DBConnectionString1 (MySettings)" DbObjectName="SIS_DB.dbo.Logs" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
589 <DeleteCommand>
590 <DbCommand CommandType="Text" ModifiedByUser="false">
591 <CommandText>DELETE FROM [dbo].[Logs] WHERE (([ID] = @Original_ID) AND ([UserID] = @Original_UserID) AND ([Date] = @Original_Date))</CommandText>
592 <Parameters>
593 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
594 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
595 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Original" />
596 </Parameters>
597 </DbCommand>
598 </DeleteCommand>
599 <InsertCommand>
600 <DbCommand CommandType="Text" ModifiedByUser="false">
601 <CommandText>INSERT INTO [dbo].[Logs] ([UserID], [Operation], [Date]) VALUES (@UserID, @Operation, @Date);
602 SELECT ID, UserID, Operation, Date FROM Logs WHERE (ID = SCOPE_IDENTITY())</CommandText>
603 <Parameters>
604 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
605 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Operation" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Operation" SourceColumnNullMapping="false" SourceVersion="Current" />
606 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Current" />
607 </Parameters>
608 </DbCommand>
609 </InsertCommand>
610 <SelectCommand>
611 <DbCommand CommandType="Text" ModifiedByUser="false">
612 <CommandText>SELECT ID, UserID, Operation, Date FROM dbo.Logs</CommandText>
613 <Parameters />
614 </DbCommand>
615 </SelectCommand>
616 <UpdateCommand>
617 <DbCommand CommandType="Text" ModifiedByUser="false">
618 <CommandText>UPDATE [dbo].[Logs] SET [UserID] = @UserID, [Operation] = @Operation, [Date] = @Date WHERE (([ID] = @Original_ID) AND ([UserID] = @Original_UserID) AND ([Date] = @Original_Date));
619 SELECT ID, UserID, Operation, Date FROM Logs WHERE (ID = @ID)</CommandText>
620 <Parameters>
621 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
622 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Operation" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Operation" SourceColumnNullMapping="false" SourceVersion="Current" />
623 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Current" />
624 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
625 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
626 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Original" />
627 <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="SIS_DB.dbo.Logs" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
628 </Parameters>
629 </DbCommand>
630 </UpdateCommand>
631 </DbSource>
632 </MainSource>
633 <Mappings>
634 <Mapping SourceColumn="ID" DataSetColumn="ID" />
635 <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
636 <Mapping SourceColumn="Operation" DataSetColumn="Operation" />
637 <Mapping SourceColumn="Date" DataSetColumn="Date" />
638 </Mappings>
639 <Sources />
640 </TableAdapter>
641 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProductTableAdapter" GeneratorDataComponentClassName="ProductTableAdapter" Name="Product" UserDataComponentName="ProductTableAdapter">
642 <MainSource>
643 <DbSource ConnectionRef="SIS_DBConnectionString1 (MySettings)" DbObjectName="SIS_DB.dbo.Product" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
644 <DeleteCommand>
645 <DbCommand CommandType="Text" ModifiedByUser="false">
646 <CommandText>DELETE FROM [dbo].[Product] WHERE (([PID] = @Original_PID) AND ([ProductCode] = @Original_ProductCode) AND ([ProductName] = @Original_ProductName) AND ([SubCategoryID] = @Original_SubCategoryID) AND ([CostPrice] = @Original_CostPrice) AND ([SellingPrice] = @Original_SellingPrice) AND ([Discount] = @Original_Discount) AND ([VAT] = @Original_VAT) AND ([ReorderPoint] = @Original_ReorderPoint))</CommandText>
647 <Parameters>
648 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PID" SourceColumnNullMapping="false" SourceVersion="Original" />
649 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ProductCode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ProductCode" SourceColumnNullMapping="false" SourceVersion="Original" />
650 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ProductName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="false" SourceVersion="Original" />
651 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SubCategoryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SubCategoryID" SourceColumnNullMapping="false" SourceVersion="Original" />
652 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_CostPrice" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CostPrice" SourceColumnNullMapping="false" SourceVersion="Original" />
653 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_SellingPrice" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="SellingPrice" SourceColumnNullMapping="false" SourceVersion="Original" />
654 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Discount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Discount" SourceColumnNullMapping="false" SourceVersion="Original" />
655 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_VAT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="VAT" SourceColumnNullMapping="false" SourceVersion="Original" />
656 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ReorderPoint" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReorderPoint" SourceColumnNullMapping="false" SourceVersion="Original" />
657 </Parameters>
658 </DbCommand>
659 </DeleteCommand>
660 <InsertCommand>
661 <DbCommand CommandType="Text" ModifiedByUser="false">
662 <CommandText>INSERT INTO [dbo].[Product] ([PID], [ProductCode], [ProductName], [SubCategoryID], [Description], [CostPrice], [SellingPrice], [Discount], [VAT], [ReorderPoint]) VALUES (@PID, @ProductCode, @ProductName, @SubCategoryID, @Description, @CostPrice, @SellingPrice, @Discount, @VAT, @ReorderPoint);
663 SELECT PID, ProductCode, ProductName, SubCategoryID, Description, CostPrice, SellingPrice, Discount, VAT, ReorderPoint FROM Product WHERE (PID = @PID)</CommandText>
664 <Parameters>
665 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PID" SourceColumnNullMapping="false" SourceVersion="Current" />
666 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ProductCode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ProductCode" SourceColumnNullMapping="false" SourceVersion="Current" />
667 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ProductName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="false" SourceVersion="Current" />
668 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SubCategoryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SubCategoryID" SourceColumnNullMapping="false" SourceVersion="Current" />
669 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
670 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CostPrice" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CostPrice" SourceColumnNullMapping="false" SourceVersion="Current" />
671 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@SellingPrice" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="SellingPrice" SourceColumnNullMapping="false" SourceVersion="Current" />
672 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Discount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Discount" SourceColumnNullMapping="false" SourceVersion="Current" />
673 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@VAT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="VAT" SourceColumnNullMapping="false" SourceVersion="Current" />
674 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ReorderPoint" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReorderPoint" SourceColumnNullMapping="false" SourceVersion="Current" />
675 </Parameters>
676 </DbCommand>
677 </InsertCommand>
678 <SelectCommand>
679 <DbCommand CommandType="Text" ModifiedByUser="false">
680 <CommandText>SELECT PID, ProductCode, ProductName, SubCategoryID, Description, CostPrice, SellingPrice, Discount, VAT, ReorderPoint FROM dbo.Product</CommandText>
681 <Parameters />
682 </DbCommand>
683 </SelectCommand>
684 <UpdateCommand>
685 <DbCommand CommandType="Text" ModifiedByUser="false">
686 <CommandText>UPDATE [dbo].[Product] SET [PID] = @PID, [ProductCode] = @ProductCode, [ProductName] = @ProductName, [SubCategoryID] = @SubCategoryID, [Description] = @Description, [CostPrice] = @CostPrice, [SellingPrice] = @SellingPrice, [Discount] = @Discount, [VAT] = @VAT, [ReorderPoint] = @ReorderPoint WHERE (([PID] = @Original_PID) AND ([ProductCode] = @Original_ProductCode) AND ([ProductName] = @Original_ProductName) AND ([SubCategoryID] = @Original_SubCategoryID) AND ([CostPrice] = @Original_CostPrice) AND ([SellingPrice] = @Original_SellingPrice) AND ([Discount] = @Original_Discount) AND ([VAT] = @Original_VAT) AND ([ReorderPoint] = @Original_ReorderPoint));
687 SELECT PID, ProductCode, ProductName, SubCategoryID, Description, CostPrice, SellingPrice, Discount, VAT, ReorderPoint FROM Product WHERE (PID = @PID)</CommandText>
688 <Parameters>
689 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PID" SourceColumnNullMapping="false" SourceVersion="Current" />
690 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ProductCode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ProductCode" SourceColumnNullMapping="false" SourceVersion="Current" />
691 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ProductName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="false" SourceVersion="Current" />
692 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SubCategoryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SubCategoryID" SourceColumnNullMapping="false" SourceVersion="Current" />
693 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
694 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CostPrice" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CostPrice" SourceColumnNullMapping="false" SourceVersion="Current" />
695 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@SellingPrice" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="SellingPrice" SourceColumnNullMapping="false" SourceVersion="Current" />
696 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Discount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Discount" SourceColumnNullMapping="false" SourceVersion="Current" />
697 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@VAT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="VAT" SourceColumnNullMapping="false" SourceVersion="Current" />
698 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ReorderPoint" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReorderPoint" SourceColumnNullMapping="false" SourceVersion="Current" />
699 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PID" SourceColumnNullMapping="false" SourceVersion="Original" />
700 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ProductCode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ProductCode" SourceColumnNullMapping="false" SourceVersion="Original" />
701 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ProductName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="false" SourceVersion="Original" />
702 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SubCategoryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SubCategoryID" SourceColumnNullMapping="false" SourceVersion="Original" />
703 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_CostPrice" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CostPrice" SourceColumnNullMapping="false" SourceVersion="Original" />
704 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_SellingPrice" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="SellingPrice" SourceColumnNullMapping="false" SourceVersion="Original" />
705 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Discount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Discount" SourceColumnNullMapping="false" SourceVersion="Original" />
706 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_VAT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="VAT" SourceColumnNullMapping="false" SourceVersion="Original" />
707 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ReorderPoint" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReorderPoint" SourceColumnNullMapping="false" SourceVersion="Original" />
708 </Parameters>
709 </DbCommand>
710 </UpdateCommand>
711 </DbSource>
712 </MainSource>
713 <Mappings>
714 <Mapping SourceColumn="PID" DataSetColumn="PID" />
715 <Mapping SourceColumn="ProductCode" DataSetColumn="ProductCode" />
716 <Mapping SourceColumn="ProductName" DataSetColumn="ProductName" />
717 <Mapping SourceColumn="SubCategoryID" DataSetColumn="SubCategoryID" />
718 <Mapping SourceColumn="Description" DataSetColumn="Description" />
719 <Mapping SourceColumn="CostPrice" DataSetColumn="CostPrice" />
720 <Mapping SourceColumn="SellingPrice" DataSetColumn="SellingPrice" />
721 <Mapping SourceColumn="Discount" DataSetColumn="Discount" />
722 <Mapping SourceColumn="VAT" DataSetColumn="VAT" />
723 <Mapping SourceColumn="ReorderPoint" DataSetColumn="ReorderPoint" />
724 </Mappings>
725 <Sources />
726 </TableAdapter>
727 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Product_JoinTableAdapter" GeneratorDataComponentClassName="Product_JoinTableAdapter" Name="Product_Join" UserDataComponentName="Product_JoinTableAdapter">
728 <MainSource>
729 <DbSource ConnectionRef="SIS_DBConnectionString1 (MySettings)" DbObjectName="SIS_DB.dbo.Product_Join" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
730 <DeleteCommand>
731 <DbCommand CommandType="Text" ModifiedByUser="false">
732 <CommandText>DELETE FROM [dbo].[Product_Join] WHERE (([Id] = @Original_Id) AND ([ProductID] = @Original_ProductID))</CommandText>
733 <Parameters>
734 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
735 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
736 </Parameters>
737 </DbCommand>
738 </DeleteCommand>
739 <InsertCommand>
740 <DbCommand CommandType="Text" ModifiedByUser="false">
741 <CommandText>INSERT INTO [dbo].[Product_Join] ([ProductID], [Photo]) VALUES (@ProductID, @Photo);
742 SELECT Id, ProductID, Photo FROM Product_Join WHERE (Id = SCOPE_IDENTITY())</CommandText>
743 <Parameters>
744 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
745 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Photo" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Photo" SourceColumnNullMapping="false" SourceVersion="Current" />
746 </Parameters>
747 </DbCommand>
748 </InsertCommand>
749 <SelectCommand>
750 <DbCommand CommandType="Text" ModifiedByUser="false">
751 <CommandText>SELECT Id, ProductID, Photo FROM dbo.Product_Join</CommandText>
752 <Parameters />
753 </DbCommand>
754 </SelectCommand>
755 <UpdateCommand>
756 <DbCommand CommandType="Text" ModifiedByUser="false">
757 <CommandText>UPDATE [dbo].[Product_Join] SET [ProductID] = @ProductID, [Photo] = @Photo WHERE (([Id] = @Original_Id) AND ([ProductID] = @Original_ProductID));
758 SELECT Id, ProductID, Photo FROM Product_Join WHERE (Id = @Id)</CommandText>
759 <Parameters>
760 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
761 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Photo" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Photo" SourceColumnNullMapping="false" SourceVersion="Current" />
762 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
763 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
764 <Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="Id" DataSourceName="SIS_DB.dbo.Product_Join" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
765 </Parameters>
766 </DbCommand>
767 </UpdateCommand>
768 </DbSource>
769 </MainSource>
770 <Mappings>
771 <Mapping SourceColumn="Id" DataSetColumn="Id" />
772 <Mapping SourceColumn="ProductID" DataSetColumn="ProductID" />
773 <Mapping SourceColumn="Photo" DataSetColumn="Photo" />
774 </Mappings>
775 <Sources />
776 </TableAdapter>
777 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="QuotationTableAdapter" GeneratorDataComponentClassName="QuotationTableAdapter" Name="Quotation" UserDataComponentName="QuotationTableAdapter">
778 <MainSource>
779 <DbSource ConnectionRef="SIS_DBConnectionString1 (MySettings)" DbObjectName="SIS_DB.dbo.Quotation" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
780 <DeleteCommand>
781 <DbCommand CommandType="Text" ModifiedByUser="false">
782 <CommandText>DELETE FROM [dbo].[Quotation] WHERE (([Q_ID] = @Original_Q_ID) AND ([QuotationNo] = @Original_QuotationNo) AND ([Date] = @Original_Date) AND ([CustomerID] = @Original_CustomerID) AND ([GrandTotal] = @Original_GrandTotal))</CommandText>
783 <Parameters>
784 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Q_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Q_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
785 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_QuotationNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="QuotationNo" SourceColumnNullMapping="false" SourceVersion="Original" />
786 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Original" />
787 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CustomerID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="false" SourceVersion="Original" />
788 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_GrandTotal" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="GrandTotal" SourceColumnNullMapping="false" SourceVersion="Original" />
789 </Parameters>
790 </DbCommand>
791 </DeleteCommand>
792 <InsertCommand>
793 <DbCommand CommandType="Text" ModifiedByUser="false">
794 <CommandText>INSERT INTO [dbo].[Quotation] ([Q_ID], [QuotationNo], [Date], [CustomerID], [GrandTotal], [Remarks]) VALUES (@Q_ID, @QuotationNo, @Date, @CustomerID, @GrandTotal, @Remarks);
795 SELECT Q_ID, QuotationNo, Date, CustomerID, GrandTotal, Remarks FROM Quotation WHERE (Q_ID = @Q_ID)</CommandText>
796 <Parameters>
797 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Q_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Q_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
798 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@QuotationNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="QuotationNo" SourceColumnNullMapping="false" SourceVersion="Current" />
799 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Current" />
800 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CustomerID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="false" SourceVersion="Current" />
801 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@GrandTotal" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="GrandTotal" SourceColumnNullMapping="false" SourceVersion="Current" />
802 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remarks" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remarks" SourceColumnNullMapping="false" SourceVersion="Current" />
803 </Parameters>
804 </DbCommand>
805 </InsertCommand>
806 <SelectCommand>
807 <DbCommand CommandType="Text" ModifiedByUser="false">
808 <CommandText>SELECT Q_ID, QuotationNo, Date, CustomerID, GrandTotal, Remarks FROM dbo.Quotation</CommandText>
809 <Parameters />
810 </DbCommand>
811 </SelectCommand>
812 <UpdateCommand>
813 <DbCommand CommandType="Text" ModifiedByUser="false">
814 <CommandText>UPDATE [dbo].[Quotation] SET [Q_ID] = @Q_ID, [QuotationNo] = @QuotationNo, [Date] = @Date, [CustomerID] = @CustomerID, [GrandTotal] = @GrandTotal, [Remarks] = @Remarks WHERE (([Q_ID] = @Original_Q_ID) AND ([QuotationNo] = @Original_QuotationNo) AND ([Date] = @Original_Date) AND ([CustomerID] = @Original_CustomerID) AND ([GrandTotal] = @Original_GrandTotal));
815 SELECT Q_ID, QuotationNo, Date, CustomerID, GrandTotal, Remarks FROM Quotation WHERE (Q_ID = @Q_ID)</CommandText>
816 <Parameters>
817 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Q_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Q_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
818 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@QuotationNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="QuotationNo" SourceColumnNullMapping="false" SourceVersion="Current" />
819 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Current" />
820 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CustomerID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="false" SourceVersion="Current" />
821 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@GrandTotal" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="GrandTotal" SourceColumnNullMapping="false" SourceVersion="Current" />
822 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remarks" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remarks" SourceColumnNullMapping="false" SourceVersion="Current" />
823 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Q_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Q_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
824 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_QuotationNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="QuotationNo" SourceColumnNullMapping="false" SourceVersion="Original" />
825 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Original" />
826 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CustomerID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="false" SourceVersion="Original" />
827 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_GrandTotal" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="GrandTotal" SourceColumnNullMapping="false" SourceVersion="Original" />
828 </Parameters>
829 </DbCommand>
830 </UpdateCommand>
831 </DbSource>
832 </MainSource>
833 <Mappings>
834 <Mapping SourceColumn="Q_ID" DataSetColumn="Q_ID" />
835 <Mapping SourceColumn="QuotationNo" DataSetColumn="QuotationNo" />
836 <Mapping SourceColumn="Date" DataSetColumn="Date" />
837 <Mapping SourceColumn="CustomerID" DataSetColumn="CustomerID" />
838 <Mapping SourceColumn="GrandTotal" DataSetColumn="GrandTotal" />
839 <Mapping SourceColumn="Remarks" DataSetColumn="Remarks" />
840 </Mappings>
841 <Sources />
842 </TableAdapter>
843 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Quotation_JoinTableAdapter" GeneratorDataComponentClassName="Quotation_JoinTableAdapter" Name="Quotation_Join" UserDataComponentName="Quotation_JoinTableAdapter">
844 <MainSource>
845 <DbSource ConnectionRef="SIS_DBConnectionString1 (MySettings)" DbObjectName="SIS_DB.dbo.Quotation_Join" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
846 <DeleteCommand>
847 <DbCommand CommandType="Text" ModifiedByUser="false">
848 <CommandText>DELETE FROM [dbo].[Quotation_Join] WHERE (([QJ_ID] = @Original_QJ_ID) AND ([QuotationID] = @Original_QuotationID) AND ([ProductID] = @Original_ProductID) AND ([Cost] = @Original_Cost) AND ([Qty] = @Original_Qty) AND ([Amount] = @Original_Amount) AND ([DiscountPer] = @Original_DiscountPer) AND ([Discount] = @Original_Discount) AND ([VATPer] = @Original_VATPer) AND ([VAT] = @Original_VAT) AND ([TotalAmount] = @Original_TotalAmount))</CommandText>
849 <Parameters>
850 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_QJ_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QJ_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
851 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_QuotationID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QuotationID" SourceColumnNullMapping="false" SourceVersion="Original" />
852 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
853 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Cost" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Cost" SourceColumnNullMapping="false" SourceVersion="Original" />
854 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Qty" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Qty" SourceColumnNullMapping="false" SourceVersion="Original" />
855 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Amount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Amount" SourceColumnNullMapping="false" SourceVersion="Original" />
856 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_DiscountPer" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DiscountPer" SourceColumnNullMapping="false" SourceVersion="Original" />
857 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Discount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Discount" SourceColumnNullMapping="false" SourceVersion="Original" />
858 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_VATPer" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="VATPer" SourceColumnNullMapping="false" SourceVersion="Original" />
859 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_VAT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="VAT" SourceColumnNullMapping="false" SourceVersion="Original" />
860 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TotalAmount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalAmount" SourceColumnNullMapping="false" SourceVersion="Original" />
861 </Parameters>
862 </DbCommand>
863 </DeleteCommand>
864 <InsertCommand>
865 <DbCommand CommandType="Text" ModifiedByUser="false">
866 <CommandText>INSERT INTO [dbo].[Quotation_Join] ([QJ_ID], [QuotationID], [ProductID], [Cost], [Qty], [Amount], [DiscountPer], [Discount], [VATPer], [VAT], [TotalAmount]) VALUES (@QJ_ID, @QuotationID, @ProductID, @Cost, @Qty, @Amount, @DiscountPer, @Discount, @VATPer, @VAT, @TotalAmount);
867 SELECT QJ_ID, QuotationID, ProductID, Cost, Qty, Amount, DiscountPer, Discount, VATPer, VAT, TotalAmount FROM Quotation_Join WHERE (QJ_ID = @QJ_ID)</CommandText>
868 <Parameters>
869 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@QJ_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QJ_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
870 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@QuotationID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QuotationID" SourceColumnNullMapping="false" SourceVersion="Current" />
871 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
872 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Cost" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Cost" SourceColumnNullMapping="false" SourceVersion="Current" />
873 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Qty" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Qty" SourceColumnNullMapping="false" SourceVersion="Current" />
874 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Amount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Amount" SourceColumnNullMapping="false" SourceVersion="Current" />
875 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@DiscountPer" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DiscountPer" SourceColumnNullMapping="false" SourceVersion="Current" />
876 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Discount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Discount" SourceColumnNullMapping="false" SourceVersion="Current" />
877 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@VATPer" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="VATPer" SourceColumnNullMapping="false" SourceVersion="Current" />
878 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@VAT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="VAT" SourceColumnNullMapping="false" SourceVersion="Current" />
879 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TotalAmount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalAmount" SourceColumnNullMapping="false" SourceVersion="Current" />
880 </Parameters>
881 </DbCommand>
882 </InsertCommand>
883 <SelectCommand>
884 <DbCommand CommandType="Text" ModifiedByUser="false">
885 <CommandText>SELECT QJ_ID, QuotationID, ProductID, Cost, Qty, Amount, DiscountPer, Discount, VATPer, VAT, TotalAmount FROM dbo.Quotation_Join</CommandText>
886 <Parameters />
887 </DbCommand>
888 </SelectCommand>
889 <UpdateCommand>
890 <DbCommand CommandType="Text" ModifiedByUser="false">
891 <CommandText>UPDATE [dbo].[Quotation_Join] SET [QJ_ID] = @QJ_ID, [QuotationID] = @QuotationID, [ProductID] = @ProductID, [Cost] = @Cost, [Qty] = @Qty, [Amount] = @Amount, [DiscountPer] = @DiscountPer, [Discount] = @Discount, [VATPer] = @VATPer, [VAT] = @VAT, [TotalAmount] = @TotalAmount WHERE (([QJ_ID] = @Original_QJ_ID) AND ([QuotationID] = @Original_QuotationID) AND ([ProductID] = @Original_ProductID) AND ([Cost] = @Original_Cost) AND ([Qty] = @Original_Qty) AND ([Amount] = @Original_Amount) AND ([DiscountPer] = @Original_DiscountPer) AND ([Discount] = @Original_Discount) AND ([VATPer] = @Original_VATPer) AND ([VAT] = @Original_VAT) AND ([TotalAmount] = @Original_TotalAmount));
892 SELECT QJ_ID, QuotationID, ProductID, Cost, Qty, Amount, DiscountPer, Discount, VATPer, VAT, TotalAmount FROM Quotation_Join WHERE (QJ_ID = @QJ_ID)</CommandText>
893 <Parameters>
894 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@QJ_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QJ_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
895 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@QuotationID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QuotationID" SourceColumnNullMapping="false" SourceVersion="Current" />
896 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
897 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Cost" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Cost" SourceColumnNullMapping="false" SourceVersion="Current" />
898 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Qty" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Qty" SourceColumnNullMapping="false" SourceVersion="Current" />
899 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Amount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Amount" SourceColumnNullMapping="false" SourceVersion="Current" />
900 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@DiscountPer" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DiscountPer" SourceColumnNullMapping="false" SourceVersion="Current" />
901 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Discount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Discount" SourceColumnNullMapping="false" SourceVersion="Current" />
902 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@VATPer" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="VATPer" SourceColumnNullMapping="false" SourceVersion="Current" />
903 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@VAT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="VAT" SourceColumnNullMapping="false" SourceVersion="Current" />
904 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TotalAmount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalAmount" SourceColumnNullMapping="false" SourceVersion="Current" />
905 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_QJ_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QJ_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
906 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_QuotationID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QuotationID" SourceColumnNullMapping="false" SourceVersion="Original" />
907 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
908 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Cost" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Cost" SourceColumnNullMapping="false" SourceVersion="Original" />
909 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Qty" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Qty" SourceColumnNullMapping="false" SourceVersion="Original" />
910 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Amount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Amount" SourceColumnNullMapping="false" SourceVersion="Original" />
911 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_DiscountPer" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DiscountPer" SourceColumnNullMapping="false" SourceVersion="Original" />
912 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Discount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Discount" SourceColumnNullMapping="false" SourceVersion="Original" />
913 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_VATPer" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="VATPer" SourceColumnNullMapping="false" SourceVersion="Original" />
914 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_VAT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="VAT" SourceColumnNullMapping="false" SourceVersion="Original" />
915 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TotalAmount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalAmount" SourceColumnNullMapping="false" SourceVersion="Original" />
916 </Parameters>
917 </DbCommand>
918 </UpdateCommand>
919 </DbSource>
920 </MainSource>
921 <Mappings>
922 <Mapping SourceColumn="QJ_ID" DataSetColumn="QJ_ID" />
923 <Mapping SourceColumn="QuotationID" DataSetColumn="QuotationID" />
924 <Mapping SourceColumn="ProductID" DataSetColumn="ProductID" />
925 <Mapping SourceColumn="Cost" DataSetColumn="Cost" />
926 <Mapping SourceColumn="Qty" DataSetColumn="Qty" />
927 <Mapping SourceColumn="Amount" DataSetColumn="Amount" />
928 <Mapping SourceColumn="DiscountPer" DataSetColumn="DiscountPer" />
929 <Mapping SourceColumn="Discount" DataSetColumn="Discount" />
930 <Mapping SourceColumn="VATPer" DataSetColumn="VATPer" />
931 <Mapping SourceColumn="VAT" DataSetColumn="VAT" />
932 <Mapping SourceColumn="TotalAmount" DataSetColumn="TotalAmount" />
933 </Mappings>
934 <Sources />
935 </TableAdapter>
936 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RegistrationTableAdapter" GeneratorDataComponentClassName="RegistrationTableAdapter" Name="Registration" UserDataComponentName="RegistrationTableAdapter">
937 <MainSource>
938 <DbSource ConnectionRef="SIS_DBConnectionString1 (MySettings)" DbObjectName="SIS_DB.dbo.Registration" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
939 <DeleteCommand>
940 <DbCommand CommandType="Text" ModifiedByUser="false">
941 <CommandText>DELETE FROM [dbo].[Registration] WHERE (([UserID] = @Original_UserID) AND ([UserType] = @Original_UserType) AND ([Password] = @Original_Password) AND ([Name] = @Original_Name) AND ([ContactNo] = @Original_ContactNo) AND ((@IsNull_EmailID = 1 AND [EmailID] IS NULL) OR ([EmailID] = @Original_EmailID)) AND ((@IsNull_JoiningDate = 1 AND [JoiningDate] IS NULL) OR ([JoiningDate] = @Original_JoiningDate)))</CommandText>
942 <Parameters>
943 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
944 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_UserType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="UserType" SourceColumnNullMapping="false" SourceVersion="Original" />
945 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Password" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Original" />
946 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
947 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Original" />
948 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmailID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmailID" SourceColumnNullMapping="true" SourceVersion="Original" />
949 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_EmailID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmailID" SourceColumnNullMapping="false" SourceVersion="Original" />
950 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JoiningDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JoiningDate" SourceColumnNullMapping="true" SourceVersion="Original" />
951 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_JoiningDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="JoiningDate" SourceColumnNullMapping="false" SourceVersion="Original" />
952 </Parameters>
953 </DbCommand>
954 </DeleteCommand>
955 <InsertCommand>
956 <DbCommand CommandType="Text" ModifiedByUser="false">
957 <CommandText>INSERT INTO [dbo].[Registration] ([UserID], [UserType], [Password], [Name], [ContactNo], [EmailID], [JoiningDate]) VALUES (@UserID, @UserType, @Password, @Name, @ContactNo, @EmailID, @JoiningDate);
958 SELECT UserID, UserType, Password, Name, ContactNo, EmailID, JoiningDate FROM Registration WHERE (UserID = @UserID)</CommandText>
959 <Parameters>
960 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
961 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@UserType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="UserType" SourceColumnNullMapping="false" SourceVersion="Current" />
962 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
963 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
964 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Current" />
965 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EmailID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmailID" SourceColumnNullMapping="false" SourceVersion="Current" />
966 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@JoiningDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="JoiningDate" SourceColumnNullMapping="false" SourceVersion="Current" />
967 </Parameters>
968 </DbCommand>
969 </InsertCommand>
970 <SelectCommand>
971 <DbCommand CommandType="Text" ModifiedByUser="false">
972 <CommandText>SELECT UserID, UserType, Password, Name, ContactNo, EmailID, JoiningDate FROM dbo.Registration</CommandText>
973 <Parameters />
974 </DbCommand>
975 </SelectCommand>
976 <UpdateCommand>
977 <DbCommand CommandType="Text" ModifiedByUser="false">
978 <CommandText>UPDATE [dbo].[Registration] SET [UserID] = @UserID, [UserType] = @UserType, [Password] = @Password, [Name] = @Name, [ContactNo] = @ContactNo, [EmailID] = @EmailID, [JoiningDate] = @JoiningDate WHERE (([UserID] = @Original_UserID) AND ([UserType] = @Original_UserType) AND ([Password] = @Original_Password) AND ([Name] = @Original_Name) AND ([ContactNo] = @Original_ContactNo) AND ((@IsNull_EmailID = 1 AND [EmailID] IS NULL) OR ([EmailID] = @Original_EmailID)) AND ((@IsNull_JoiningDate = 1 AND [JoiningDate] IS NULL) OR ([JoiningDate] = @Original_JoiningDate)));
979 SELECT UserID, UserType, Password, Name, ContactNo, EmailID, JoiningDate FROM Registration WHERE (UserID = @UserID)</CommandText>
980 <Parameters>
981 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
982 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@UserType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="UserType" SourceColumnNullMapping="false" SourceVersion="Current" />
983 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
984 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
985 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Current" />
986 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EmailID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmailID" SourceColumnNullMapping="false" SourceVersion="Current" />
987 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@JoiningDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="JoiningDate" SourceColumnNullMapping="false" SourceVersion="Current" />
988 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
989 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_UserType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="UserType" SourceColumnNullMapping="false" SourceVersion="Original" />
990 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Password" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Original" />
991 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
992 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Original" />
993 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmailID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmailID" SourceColumnNullMapping="true" SourceVersion="Original" />
994 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_EmailID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmailID" SourceColumnNullMapping="false" SourceVersion="Original" />
995 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JoiningDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JoiningDate" SourceColumnNullMapping="true" SourceVersion="Original" />
996 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_JoiningDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="JoiningDate" SourceColumnNullMapping="false" SourceVersion="Original" />
997 </Parameters>
998 </DbCommand>
999 </UpdateCommand>
1000 </DbSource>
1001 </MainSource>
1002 <Mappings>
1003 <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
1004 <Mapping SourceColumn="UserType" DataSetColumn="UserType" />
1005 <Mapping SourceColumn="Password" DataSetColumn="Password" />
1006 <Mapping SourceColumn="Name" DataSetColumn="Name" />
1007 <Mapping SourceColumn="ContactNo" DataSetColumn="ContactNo" />
1008 <Mapping SourceColumn="EmailID" DataSetColumn="EmailID" />
1009 <Mapping SourceColumn="JoiningDate" DataSetColumn="JoiningDate" />
1010 </Mappings>
1011 <Sources />
1012 </TableAdapter>
1013 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ServiceTableAdapter" GeneratorDataComponentClassName="ServiceTableAdapter" Name="Service" UserDataComponentName="ServiceTableAdapter">
1014 <MainSource>
1015 <DbSource ConnectionRef="SIS_DBConnectionString1 (MySettings)" DbObjectName="SIS_DB.dbo.Service" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
1016 <DeleteCommand>
1017 <DbCommand CommandType="Text" ModifiedByUser="false">
1018 <CommandText>DELETE FROM [dbo].[Service] WHERE (([S_ID] = @Original_S_ID) AND ([ServiceCode] = @Original_ServiceCode) AND ([CustomerID] = @Original_CustomerID) AND ((@IsNull_ServiceType = 1 AND [ServiceType] IS NULL) OR ([ServiceType] = @Original_ServiceType)) AND ([ServiceCreationDate] = @Original_ServiceCreationDate) AND ([ChargesQuote] = @Original_ChargesQuote) AND ([AdvanceDeposit] = @Original_AdvanceDeposit) AND ([EstimatedRepairDate] = @Original_EstimatedRepairDate) AND ([Status] = @Original_Status))</CommandText>
1019 <Parameters>
1020 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_S_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="S_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
1021 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ServiceCode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ServiceCode" SourceColumnNullMapping="false" SourceVersion="Original" />
1022 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CustomerID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="false" SourceVersion="Original" />
1023 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ServiceType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ServiceType" SourceColumnNullMapping="true" SourceVersion="Original" />
1024 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ServiceType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ServiceType" SourceColumnNullMapping="false" SourceVersion="Original" />
1025 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ServiceCreationDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ServiceCreationDate" SourceColumnNullMapping="false" SourceVersion="Original" />
1026 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ChargesQuote" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ChargesQuote" SourceColumnNullMapping="false" SourceVersion="Original" />
1027 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_AdvanceDeposit" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="AdvanceDeposit" SourceColumnNullMapping="false" SourceVersion="Original" />
1028 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EstimatedRepairDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EstimatedRepairDate" SourceColumnNullMapping="false" SourceVersion="Original" />
1029 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Status" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Original" />
1030 </Parameters>
1031 </DbCommand>
1032 </DeleteCommand>
1033 <InsertCommand>
1034 <DbCommand CommandType="Text" ModifiedByUser="false">
1035 <CommandText>INSERT INTO [dbo].[Service] ([S_ID], [ServiceCode], [CustomerID], [ServiceType], [ServiceCreationDate], [ItemDescription], [ProblemDescription], [ChargesQuote], [AdvanceDeposit], [EstimatedRepairDate], [Remarks], [Status]) VALUES (@S_ID, @ServiceCode, @CustomerID, @ServiceType, @ServiceCreationDate, @ItemDescription, @ProblemDescription, @ChargesQuote, @AdvanceDeposit, @EstimatedRepairDate, @Remarks, @Status);
1036 SELECT S_ID, ServiceCode, CustomerID, ServiceType, ServiceCreationDate, ItemDescription, ProblemDescription, ChargesQuote, AdvanceDeposit, EstimatedRepairDate, Remarks, Status FROM Service WHERE (S_ID = @S_ID)</CommandText>
1037 <Parameters>
1038 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@S_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="S_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
1039 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ServiceCode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ServiceCode" SourceColumnNullMapping="false" SourceVersion="Current" />
1040 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CustomerID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="false" SourceVersion="Current" />
1041 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ServiceType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ServiceType" SourceColumnNullMapping="false" SourceVersion="Current" />
1042 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ServiceCreationDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ServiceCreationDate" SourceColumnNullMapping="false" SourceVersion="Current" />
1043 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ItemDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ItemDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
1044 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProblemDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProblemDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
1045 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ChargesQuote" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ChargesQuote" SourceColumnNullMapping="false" SourceVersion="Current" />
1046 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@AdvanceDeposit" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="AdvanceDeposit" SourceColumnNullMapping="false" SourceVersion="Current" />
1047 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EstimatedRepairDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EstimatedRepairDate" SourceColumnNullMapping="false" SourceVersion="Current" />
1048 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remarks" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remarks" SourceColumnNullMapping="false" SourceVersion="Current" />
1049 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
1050 </Parameters>
1051 </DbCommand>
1052 </InsertCommand>
1053 <SelectCommand>
1054 <DbCommand CommandType="Text" ModifiedByUser="false">
1055 <CommandText>SELECT S_ID, ServiceCode, CustomerID, ServiceType, ServiceCreationDate, ItemDescription, ProblemDescription, ChargesQuote, AdvanceDeposit, EstimatedRepairDate, Remarks, Status FROM dbo.Service</CommandText>
1056 <Parameters />
1057 </DbCommand>
1058 </SelectCommand>
1059 <UpdateCommand>
1060 <DbCommand CommandType="Text" ModifiedByUser="false">
1061 <CommandText>UPDATE [dbo].[Service] SET [S_ID] = @S_ID, [ServiceCode] = @ServiceCode, [CustomerID] = @CustomerID, [ServiceType] = @ServiceType, [ServiceCreationDate] = @ServiceCreationDate, [ItemDescription] = @ItemDescription, [ProblemDescription] = @ProblemDescription, [ChargesQuote] = @ChargesQuote, [AdvanceDeposit] = @AdvanceDeposit, [EstimatedRepairDate] = @EstimatedRepairDate, [Remarks] = @Remarks, [Status] = @Status WHERE (([S_ID] = @Original_S_ID) AND ([ServiceCode] = @Original_ServiceCode) AND ([CustomerID] = @Original_CustomerID) AND ((@IsNull_ServiceType = 1 AND [ServiceType] IS NULL) OR ([ServiceType] = @Original_ServiceType)) AND ([ServiceCreationDate] = @Original_ServiceCreationDate) AND ([ChargesQuote] = @Original_ChargesQuote) AND ([AdvanceDeposit] = @Original_AdvanceDeposit) AND ([EstimatedRepairDate] = @Original_EstimatedRepairDate) AND ([Status] = @Original_Status));
1062 SELECT S_ID, ServiceCode, CustomerID, ServiceType, ServiceCreationDate, ItemDescription, ProblemDescription, ChargesQuote, AdvanceDeposit, EstimatedRepairDate, Remarks, Status FROM Service WHERE (S_ID = @S_ID)</CommandText>
1063 <Parameters>
1064 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@S_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="S_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
1065 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ServiceCode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ServiceCode" SourceColumnNullMapping="false" SourceVersion="Current" />
1066 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CustomerID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="false" SourceVersion="Current" />
1067 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ServiceType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ServiceType" SourceColumnNullMapping="false" SourceVersion="Current" />
1068 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ServiceCreationDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ServiceCreationDate" SourceColumnNullMapping="false" SourceVersion="Current" />
1069 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ItemDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ItemDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
1070 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProblemDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProblemDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
1071 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ChargesQuote" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ChargesQuote" SourceColumnNullMapping="false" SourceVersion="Current" />
1072 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@AdvanceDeposit" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="AdvanceDeposit" SourceColumnNullMapping="false" SourceVersion="Current" />
1073 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EstimatedRepairDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EstimatedRepairDate" SourceColumnNullMapping="false" SourceVersion="Current" />
1074 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remarks" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remarks" SourceColumnNullMapping="false" SourceVersion="Current" />
1075 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
1076 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_S_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="S_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
1077 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ServiceCode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ServiceCode" SourceColumnNullMapping="false" SourceVersion="Original" />
1078 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CustomerID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="false" SourceVersion="Original" />
1079 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ServiceType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ServiceType" SourceColumnNullMapping="true" SourceVersion="Original" />
1080 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ServiceType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ServiceType" SourceColumnNullMapping="false" SourceVersion="Original" />
1081 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ServiceCreationDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ServiceCreationDate" SourceColumnNullMapping="false" SourceVersion="Original" />
1082 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ChargesQuote" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ChargesQuote" SourceColumnNullMapping="false" SourceVersion="Original" />
1083 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_AdvanceDeposit" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="AdvanceDeposit" SourceColumnNullMapping="false" SourceVersion="Original" />
1084 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EstimatedRepairDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EstimatedRepairDate" SourceColumnNullMapping="false" SourceVersion="Original" />
1085 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Status" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Original" />
1086 </Parameters>
1087 </DbCommand>
1088 </UpdateCommand>
1089 </DbSource>
1090 </MainSource>
1091 <Mappings>
1092 <Mapping SourceColumn="S_ID" DataSetColumn="S_ID" />
1093 <Mapping SourceColumn="ServiceCode" DataSetColumn="ServiceCode" />
1094 <Mapping SourceColumn="CustomerID" DataSetColumn="CustomerID" />
1095 <Mapping SourceColumn="ServiceType" DataSetColumn="ServiceType" />
1096 <Mapping SourceColumn="ServiceCreationDate" DataSetColumn="ServiceCreationDate" />
1097 <Mapping SourceColumn="ItemDescription" DataSetColumn="ItemDescription" />
1098 <Mapping SourceColumn="ProblemDescription" DataSetColumn="ProblemDescription" />
1099 <Mapping SourceColumn="ChargesQuote" DataSetColumn="ChargesQuote" />
1100 <Mapping SourceColumn="AdvanceDeposit" DataSetColumn="AdvanceDeposit" />
1101 <Mapping SourceColumn="EstimatedRepairDate" DataSetColumn="EstimatedRepairDate" />
1102 <Mapping SourceColumn="Remarks" DataSetColumn="Remarks" />
1103 <Mapping SourceColumn="Status" DataSetColumn="Status" />
1104 </Mappings>
1105 <Sources />
1106 </TableAdapter>
1107 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="StockTableAdapter" GeneratorDataComponentClassName="StockTableAdapter" Name="Stock" UserDataComponentName="StockTableAdapter">
1108 <MainSource>
1109 <DbSource ConnectionRef="SIS_DBConnectionString1 (MySettings)" DbObjectName="SIS_DB.dbo.Stock" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
1110 <DeleteCommand>
1111 <DbCommand CommandType="Text" ModifiedByUser="false">
1112 <CommandText>DELETE FROM [dbo].[Stock] WHERE (([ST_ID] = @Original_ST_ID) AND ([Stock_ID] = @Original_Stock_ID) AND ([Date] = @Original_Date) AND ([SupplierID] = @Original_SupplierID) AND ([GrandTotal] = @Original_GrandTotal) AND ([TotalPayment] = @Original_TotalPayment) AND ([PaymentDue] = @Original_PaymentDue))</CommandText>
1113 <Parameters>
1114 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ST_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ST_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
1115 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Stock_ID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Stock_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
1116 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Original" />
1117 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SupplierID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SupplierID" SourceColumnNullMapping="false" SourceVersion="Original" />
1118 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_GrandTotal" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="GrandTotal" SourceColumnNullMapping="false" SourceVersion="Original" />
1119 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TotalPayment" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalPayment" SourceColumnNullMapping="false" SourceVersion="Original" />
1120 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_PaymentDue" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="PaymentDue" SourceColumnNullMapping="false" SourceVersion="Original" />
1121 </Parameters>
1122 </DbCommand>
1123 </DeleteCommand>
1124 <InsertCommand>
1125 <DbCommand CommandType="Text" ModifiedByUser="false">
1126 <CommandText>INSERT INTO [dbo].[Stock] ([ST_ID], [Stock_ID], [Date], [SupplierID], [GrandTotal], [TotalPayment], [PaymentDue], [Remarks]) VALUES (@ST_ID, @Stock_ID, @Date, @SupplierID, @GrandTotal, @TotalPayment, @PaymentDue, @Remarks);
1127 SELECT ST_ID, Stock_ID, Date, SupplierID, GrandTotal, TotalPayment, PaymentDue, Remarks FROM Stock WHERE (ST_ID = @ST_ID)</CommandText>
1128 <Parameters>
1129 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ST_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ST_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
1130 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Stock_ID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Stock_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
1131 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Current" />
1132 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SupplierID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SupplierID" SourceColumnNullMapping="false" SourceVersion="Current" />
1133 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@GrandTotal" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="GrandTotal" SourceColumnNullMapping="false" SourceVersion="Current" />
1134 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TotalPayment" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalPayment" SourceColumnNullMapping="false" SourceVersion="Current" />
1135 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@PaymentDue" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="PaymentDue" SourceColumnNullMapping="false" SourceVersion="Current" />
1136 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remarks" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remarks" SourceColumnNullMapping="false" SourceVersion="Current" />
1137 </Parameters>
1138 </DbCommand>
1139 </InsertCommand>
1140 <SelectCommand>
1141 <DbCommand CommandType="Text" ModifiedByUser="false">
1142 <CommandText>SELECT ST_ID, Stock_ID, Date, SupplierID, GrandTotal, TotalPayment, PaymentDue, Remarks FROM dbo.Stock</CommandText>
1143 <Parameters />
1144 </DbCommand>
1145 </SelectCommand>
1146 <UpdateCommand>
1147 <DbCommand CommandType="Text" ModifiedByUser="false">
1148 <CommandText>UPDATE [dbo].[Stock] SET [ST_ID] = @ST_ID, [Stock_ID] = @Stock_ID, [Date] = @Date, [SupplierID] = @SupplierID, [GrandTotal] = @GrandTotal, [TotalPayment] = @TotalPayment, [PaymentDue] = @PaymentDue, [Remarks] = @Remarks WHERE (([ST_ID] = @Original_ST_ID) AND ([Stock_ID] = @Original_Stock_ID) AND ([Date] = @Original_Date) AND ([SupplierID] = @Original_SupplierID) AND ([GrandTotal] = @Original_GrandTotal) AND ([TotalPayment] = @Original_TotalPayment) AND ([PaymentDue] = @Original_PaymentDue));
1149 SELECT ST_ID, Stock_ID, Date, SupplierID, GrandTotal, TotalPayment, PaymentDue, Remarks FROM Stock WHERE (ST_ID = @ST_ID)</CommandText>
1150 <Parameters>
1151 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ST_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ST_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
1152 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Stock_ID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Stock_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
1153 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Current" />
1154 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SupplierID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SupplierID" SourceColumnNullMapping="false" SourceVersion="Current" />
1155 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@GrandTotal" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="GrandTotal" SourceColumnNullMapping="false" SourceVersion="Current" />
1156 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TotalPayment" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalPayment" SourceColumnNullMapping="false" SourceVersion="Current" />
1157 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@PaymentDue" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="PaymentDue" SourceColumnNullMapping="false" SourceVersion="Current" />
1158 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remarks" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remarks" SourceColumnNullMapping="false" SourceVersion="Current" />
1159 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ST_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ST_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
1160 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Stock_ID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Stock_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
1161 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Original" />
1162 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SupplierID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SupplierID" SourceColumnNullMapping="false" SourceVersion="Original" />
1163 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_GrandTotal" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="GrandTotal" SourceColumnNullMapping="false" SourceVersion="Original" />
1164 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TotalPayment" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalPayment" SourceColumnNullMapping="false" SourceVersion="Original" />
1165 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_PaymentDue" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="PaymentDue" SourceColumnNullMapping="false" SourceVersion="Original" />
1166 </Parameters>
1167 </DbCommand>
1168 </UpdateCommand>
1169 </DbSource>
1170 </MainSource>
1171 <Mappings>
1172 <Mapping SourceColumn="ST_ID" DataSetColumn="ST_ID" />
1173 <Mapping SourceColumn="Stock_ID" DataSetColumn="Stock_ID" />
1174 <Mapping SourceColumn="Date" DataSetColumn="Date" />
1175 <Mapping SourceColumn="SupplierID" DataSetColumn="SupplierID" />
1176 <Mapping SourceColumn="GrandTotal" DataSetColumn="GrandTotal" />
1177 <Mapping SourceColumn="TotalPayment" DataSetColumn="TotalPayment" />
1178 <Mapping SourceColumn="PaymentDue" DataSetColumn="PaymentDue" />
1179 <Mapping SourceColumn="Remarks" DataSetColumn="Remarks" />
1180 </Mappings>
1181 <Sources />
1182 </TableAdapter>
1183 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Stock_ProductTableAdapter" GeneratorDataComponentClassName="Stock_ProductTableAdapter" Name="Stock_Product" UserDataComponentName="Stock_ProductTableAdapter">
1184 <MainSource>
1185 <DbSource ConnectionRef="SIS_DBConnectionString1 (MySettings)" DbObjectName="SIS_DB.dbo.Stock_Product" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
1186 <DeleteCommand>
1187 <DbCommand CommandType="Text" ModifiedByUser="false">
1188 <CommandText>DELETE FROM [dbo].[Stock_Product] WHERE (([SP_ID] = @Original_SP_ID) AND ([StockID] = @Original_StockID) AND ([ProductID] = @Original_ProductID) AND ([Qty] = @Original_Qty) AND ([Price] = @Original_Price) AND ([TotalAmount] = @Original_TotalAmount))</CommandText>
1189 <Parameters>
1190 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SP_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SP_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
1191 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_StockID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StockID" SourceColumnNullMapping="false" SourceVersion="Original" />
1192 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
1193 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Qty" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Qty" SourceColumnNullMapping="false" SourceVersion="Original" />
1194 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Price" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Original" />
1195 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TotalAmount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalAmount" SourceColumnNullMapping="false" SourceVersion="Original" />
1196 </Parameters>
1197 </DbCommand>
1198 </DeleteCommand>
1199 <InsertCommand>
1200 <DbCommand CommandType="Text" ModifiedByUser="false">
1201 <CommandText>INSERT INTO [dbo].[Stock_Product] ([StockID], [ProductID], [Qty], [Price], [TotalAmount]) VALUES (@StockID, @ProductID, @Qty, @Price, @TotalAmount);
1202 SELECT SP_ID, StockID, ProductID, Qty, Price, TotalAmount FROM Stock_Product WHERE (SP_ID = SCOPE_IDENTITY())</CommandText>
1203 <Parameters>
1204 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@StockID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StockID" SourceColumnNullMapping="false" SourceVersion="Current" />
1205 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
1206 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Qty" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Qty" SourceColumnNullMapping="false" SourceVersion="Current" />
1207 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Price" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Current" />
1208 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TotalAmount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalAmount" SourceColumnNullMapping="false" SourceVersion="Current" />
1209 </Parameters>
1210 </DbCommand>
1211 </InsertCommand>
1212 <SelectCommand>
1213 <DbCommand CommandType="Text" ModifiedByUser="false">
1214 <CommandText>SELECT SP_ID, StockID, ProductID, Qty, Price, TotalAmount FROM dbo.Stock_Product</CommandText>
1215 <Parameters />
1216 </DbCommand>
1217 </SelectCommand>
1218 <UpdateCommand>
1219 <DbCommand CommandType="Text" ModifiedByUser="false">
1220 <CommandText>UPDATE [dbo].[Stock_Product] SET [StockID] = @StockID, [ProductID] = @ProductID, [Qty] = @Qty, [Price] = @Price, [TotalAmount] = @TotalAmount WHERE (([SP_ID] = @Original_SP_ID) AND ([StockID] = @Original_StockID) AND ([ProductID] = @Original_ProductID) AND ([Qty] = @Original_Qty) AND ([Price] = @Original_Price) AND ([TotalAmount] = @Original_TotalAmount));
1221 SELECT SP_ID, StockID, ProductID, Qty, Price, TotalAmount FROM Stock_Product WHERE (SP_ID = @SP_ID)</CommandText>
1222 <Parameters>
1223 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@StockID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StockID" SourceColumnNullMapping="false" SourceVersion="Current" />
1224 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
1225 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Qty" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Qty" SourceColumnNullMapping="false" SourceVersion="Current" />
1226 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Price" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Current" />
1227 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TotalAmount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalAmount" SourceColumnNullMapping="false" SourceVersion="Current" />
1228 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SP_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SP_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
1229 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_StockID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StockID" SourceColumnNullMapping="false" SourceVersion="Original" />
1230 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
1231 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Qty" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Qty" SourceColumnNullMapping="false" SourceVersion="Original" />
1232 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Price" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Original" />
1233 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TotalAmount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalAmount" SourceColumnNullMapping="false" SourceVersion="Original" />
1234 <Parameter AllowDbNull="false" AutogeneratedName="SP_ID" ColumnName="SP_ID" DataSourceName="SIS_DB.dbo.Stock_Product" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SP_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SP_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
1235 </Parameters>
1236 </DbCommand>
1237 </UpdateCommand>
1238 </DbSource>
1239 </MainSource>
1240 <Mappings>
1241 <Mapping SourceColumn="SP_ID" DataSetColumn="SP_ID" />
1242 <Mapping SourceColumn="StockID" DataSetColumn="StockID" />
1243 <Mapping SourceColumn="ProductID" DataSetColumn="ProductID" />
1244 <Mapping SourceColumn="Qty" DataSetColumn="Qty" />
1245 <Mapping SourceColumn="Price" DataSetColumn="Price" />
1246 <Mapping SourceColumn="TotalAmount" DataSetColumn="TotalAmount" />
1247 </Mappings>
1248 <Sources />
1249 </TableAdapter>
1250 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SubCategoryTableAdapter" GeneratorDataComponentClassName="SubCategoryTableAdapter" Name="SubCategory" UserDataComponentName="SubCategoryTableAdapter">
1251 <MainSource>
1252 <DbSource ConnectionRef="SIS_DBConnectionString1 (MySettings)" DbObjectName="SIS_DB.dbo.SubCategory" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
1253 <DeleteCommand>
1254 <DbCommand CommandType="Text" ModifiedByUser="false">
1255 <CommandText>DELETE FROM [dbo].[SubCategory] WHERE (([ID] = @Original_ID) AND ([SubCategoryName] = @Original_SubCategoryName) AND ([Category] = @Original_Category))</CommandText>
1256 <Parameters>
1257 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
1258 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_SubCategoryName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="SubCategoryName" SourceColumnNullMapping="false" SourceVersion="Original" />
1259 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Category" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Category" SourceColumnNullMapping="false" SourceVersion="Original" />
1260 </Parameters>
1261 </DbCommand>
1262 </DeleteCommand>
1263 <InsertCommand>
1264 <DbCommand CommandType="Text" ModifiedByUser="false">
1265 <CommandText>INSERT INTO [dbo].[SubCategory] ([ID], [SubCategoryName], [Category]) VALUES (@ID, @SubCategoryName, @Category);
1266 SELECT ID, SubCategoryName, Category FROM SubCategory WHERE (ID = @ID)</CommandText>
1267 <Parameters>
1268 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
1269 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@SubCategoryName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="SubCategoryName" SourceColumnNullMapping="false" SourceVersion="Current" />
1270 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Category" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Category" SourceColumnNullMapping="false" SourceVersion="Current" />
1271 </Parameters>
1272 </DbCommand>
1273 </InsertCommand>
1274 <SelectCommand>
1275 <DbCommand CommandType="Text" ModifiedByUser="false">
1276 <CommandText>SELECT ID, SubCategoryName, Category FROM dbo.SubCategory</CommandText>
1277 <Parameters />
1278 </DbCommand>
1279 </SelectCommand>
1280 <UpdateCommand>
1281 <DbCommand CommandType="Text" ModifiedByUser="false">
1282 <CommandText>UPDATE [dbo].[SubCategory] SET [ID] = @ID, [SubCategoryName] = @SubCategoryName, [Category] = @Category WHERE (([ID] = @Original_ID) AND ([SubCategoryName] = @Original_SubCategoryName) AND ([Category] = @Original_Category));
1283 SELECT ID, SubCategoryName, Category FROM SubCategory WHERE (ID = @ID)</CommandText>
1284 <Parameters>
1285 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
1286 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@SubCategoryName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="SubCategoryName" SourceColumnNullMapping="false" SourceVersion="Current" />
1287 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Category" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Category" SourceColumnNullMapping="false" SourceVersion="Current" />
1288 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
1289 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_SubCategoryName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="SubCategoryName" SourceColumnNullMapping="false" SourceVersion="Original" />
1290 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Category" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Category" SourceColumnNullMapping="false" SourceVersion="Original" />
1291 </Parameters>
1292 </DbCommand>
1293 </UpdateCommand>
1294 </DbSource>
1295 </MainSource>
1296 <Mappings>
1297 <Mapping SourceColumn="ID" DataSetColumn="ID" />
1298 <Mapping SourceColumn="SubCategoryName" DataSetColumn="SubCategoryName" />
1299 <Mapping SourceColumn="Category" DataSetColumn="Category" />
1300 </Mappings>
1301 <Sources />
1302 </TableAdapter>
1303 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SupplierTableAdapter" GeneratorDataComponentClassName="SupplierTableAdapter" Name="Supplier" UserDataComponentName="SupplierTableAdapter">
1304 <MainSource>
1305 <DbSource ConnectionRef="SIS_DBConnectionString1 (MySettings)" DbObjectName="SIS_DB.dbo.Supplier" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
1306 <DeleteCommand>
1307 <DbCommand CommandType="Text" ModifiedByUser="false">
1308 <CommandText>DELETE FROM [dbo].[Supplier] WHERE (([ID] = @Original_ID) AND ([SupplierID] = @Original_SupplierID) AND ([Name] = @Original_Name) AND ([Address] = @Original_Address) AND ([City] = @Original_City) AND ([State] = @Original_State) AND ((@IsNull_ZipCode = 1 AND [ZipCode] IS NULL) OR ([ZipCode] = @Original_ZipCode)) AND ([ContactNo] = @Original_ContactNo) AND ((@IsNull_EmailID = 1 AND [EmailID] IS NULL) OR ([EmailID] = @Original_EmailID)))</CommandText>
1309 <Parameters>
1310 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
1311 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_SupplierID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="SupplierID" SourceColumnNullMapping="false" SourceVersion="Original" />
1312 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
1313 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Original" />
1314 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_City" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Original" />
1315 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_State" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Original" />
1316 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ZipCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ZipCode" SourceColumnNullMapping="true" SourceVersion="Original" />
1317 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ZipCode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ZipCode" SourceColumnNullMapping="false" SourceVersion="Original" />
1318 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Original" />
1319 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmailID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmailID" SourceColumnNullMapping="true" SourceVersion="Original" />
1320 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_EmailID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmailID" SourceColumnNullMapping="false" SourceVersion="Original" />
1321 </Parameters>
1322 </DbCommand>
1323 </DeleteCommand>
1324 <InsertCommand>
1325 <DbCommand CommandType="Text" ModifiedByUser="false">
1326 <CommandText>INSERT INTO [dbo].[Supplier] ([ID], [SupplierID], [Name], [Address], [City], [State], [ZipCode], [ContactNo], [EmailID], [Remarks]) VALUES (@ID, @SupplierID, @Name, @Address, @City, @State, @ZipCode, @ContactNo, @EmailID, @Remarks);
1327 SELECT ID, SupplierID, Name, Address, City, State, ZipCode, ContactNo, EmailID, Remarks FROM Supplier WHERE (ID = @ID)</CommandText>
1328 <Parameters>
1329 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
1330 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@SupplierID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="SupplierID" SourceColumnNullMapping="false" SourceVersion="Current" />
1331 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
1332 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
1333 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@City" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Current" />
1334 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@State" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Current" />
1335 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ZipCode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ZipCode" SourceColumnNullMapping="false" SourceVersion="Current" />
1336 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Current" />
1337 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EmailID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmailID" SourceColumnNullMapping="false" SourceVersion="Current" />
1338 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remarks" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remarks" SourceColumnNullMapping="false" SourceVersion="Current" />
1339 </Parameters>
1340 </DbCommand>
1341 </InsertCommand>
1342 <SelectCommand>
1343 <DbCommand CommandType="Text" ModifiedByUser="false">
1344 <CommandText>SELECT ID, SupplierID, Name, Address, City, State, ZipCode, ContactNo, EmailID, Remarks FROM dbo.Supplier</CommandText>
1345 <Parameters />
1346 </DbCommand>
1347 </SelectCommand>
1348 <UpdateCommand>
1349 <DbCommand CommandType="Text" ModifiedByUser="false">
1350 <CommandText>UPDATE [dbo].[Supplier] SET [ID] = @ID, [SupplierID] = @SupplierID, [Name] = @Name, [Address] = @Address, [City] = @City, [State] = @State, [ZipCode] = @ZipCode, [ContactNo] = @ContactNo, [EmailID] = @EmailID, [Remarks] = @Remarks WHERE (([ID] = @Original_ID) AND ([SupplierID] = @Original_SupplierID) AND ([Name] = @Original_Name) AND ([Address] = @Original_Address) AND ([City] = @Original_City) AND ([State] = @Original_State) AND ((@IsNull_ZipCode = 1 AND [ZipCode] IS NULL) OR ([ZipCode] = @Original_ZipCode)) AND ([ContactNo] = @Original_ContactNo) AND ((@IsNull_EmailID = 1 AND [EmailID] IS NULL) OR ([EmailID] = @Original_EmailID)));
1351 SELECT ID, SupplierID, Name, Address, City, State, ZipCode, ContactNo, EmailID, Remarks FROM Supplier WHERE (ID = @ID)</CommandText>
1352 <Parameters>
1353 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
1354 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@SupplierID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="SupplierID" SourceColumnNullMapping="false" SourceVersion="Current" />
1355 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
1356 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
1357 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@City" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Current" />
1358 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@State" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Current" />
1359 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ZipCode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ZipCode" SourceColumnNullMapping="false" SourceVersion="Current" />
1360 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Current" />
1361 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EmailID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmailID" SourceColumnNullMapping="false" SourceVersion="Current" />
1362 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remarks" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remarks" SourceColumnNullMapping="false" SourceVersion="Current" />
1363 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
1364 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_SupplierID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="SupplierID" SourceColumnNullMapping="false" SourceVersion="Original" />
1365 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
1366 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Original" />
1367 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_City" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Original" />
1368 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_State" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Original" />
1369 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ZipCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ZipCode" SourceColumnNullMapping="true" SourceVersion="Original" />
1370 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ZipCode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ZipCode" SourceColumnNullMapping="false" SourceVersion="Original" />
1371 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Original" />
1372 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmailID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmailID" SourceColumnNullMapping="true" SourceVersion="Original" />
1373 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_EmailID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmailID" SourceColumnNullMapping="false" SourceVersion="Original" />
1374 </Parameters>
1375 </DbCommand>
1376 </UpdateCommand>
1377 </DbSource>
1378 </MainSource>
1379 <Mappings>
1380 <Mapping SourceColumn="ID" DataSetColumn="ID" />
1381 <Mapping SourceColumn="SupplierID" DataSetColumn="SupplierID" />
1382 <Mapping SourceColumn="Name" DataSetColumn="Name" />
1383 <Mapping SourceColumn="Address" DataSetColumn="Address" />
1384 <Mapping SourceColumn="City" DataSetColumn="City" />
1385 <Mapping SourceColumn="State" DataSetColumn="State" />
1386 <Mapping SourceColumn="ZipCode" DataSetColumn="ZipCode" />
1387 <Mapping SourceColumn="ContactNo" DataSetColumn="ContactNo" />
1388 <Mapping SourceColumn="EmailID" DataSetColumn="EmailID" />
1389 <Mapping SourceColumn="Remarks" DataSetColumn="Remarks" />
1390 </Mappings>
1391 <Sources />
1392 </TableAdapter>
1393 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Temp_StockTableAdapter" GeneratorDataComponentClassName="Temp_StockTableAdapter" Name="Temp_Stock" UserDataComponentName="Temp_StockTableAdapter">
1394 <MainSource>
1395 <DbSource ConnectionRef="SIS_DBConnectionString1 (MySettings)" DbObjectName="SIS_DB.dbo.Temp_Stock" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
1396 <DeleteCommand>
1397 <DbCommand CommandType="Text" ModifiedByUser="false">
1398 <CommandText>DELETE FROM [dbo].[Temp_Stock] WHERE (([ProductID] = @Original_ProductID) AND ([Qty] = @Original_Qty))</CommandText>
1399 <Parameters>
1400 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
1401 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Qty" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Qty" SourceColumnNullMapping="false" SourceVersion="Original" />
1402 </Parameters>
1403 </DbCommand>
1404 </DeleteCommand>
1405 <InsertCommand>
1406 <DbCommand CommandType="Text" ModifiedByUser="false">
1407 <CommandText>INSERT INTO [dbo].[Temp_Stock] ([ProductID], [Qty]) VALUES (@ProductID, @Qty);
1408 SELECT ProductID, Qty FROM Temp_Stock WHERE (ProductID = @ProductID)</CommandText>
1409 <Parameters>
1410 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
1411 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Qty" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Qty" SourceColumnNullMapping="false" SourceVersion="Current" />
1412 </Parameters>
1413 </DbCommand>
1414 </InsertCommand>
1415 <SelectCommand>
1416 <DbCommand CommandType="Text" ModifiedByUser="false">
1417 <CommandText>SELECT ProductID, Qty FROM dbo.Temp_Stock</CommandText>
1418 <Parameters />
1419 </DbCommand>
1420 </SelectCommand>
1421 <UpdateCommand>
1422 <DbCommand CommandType="Text" ModifiedByUser="false">
1423 <CommandText>UPDATE [dbo].[Temp_Stock] SET [ProductID] = @ProductID, [Qty] = @Qty WHERE (([ProductID] = @Original_ProductID) AND ([Qty] = @Original_Qty));
1424 SELECT ProductID, Qty FROM Temp_Stock WHERE (ProductID = @ProductID)</CommandText>
1425 <Parameters>
1426 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
1427 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Qty" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Qty" SourceColumnNullMapping="false" SourceVersion="Current" />
1428 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
1429 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Qty" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Qty" SourceColumnNullMapping="false" SourceVersion="Original" />
1430 </Parameters>
1431 </DbCommand>
1432 </UpdateCommand>
1433 </DbSource>
1434 </MainSource>
1435 <Mappings>
1436 <Mapping SourceColumn="ProductID" DataSetColumn="ProductID" />
1437 <Mapping SourceColumn="Qty" DataSetColumn="Qty" />
1438 </Mappings>
1439 <Sources />
1440 </TableAdapter>
1441 </Tables>
1442 <Sources />
1443 </DataSource>
1444 </xs:appinfo>
1445 </xs:annotation>
1446 <xs:element name="SIS_DBDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="SIS_DBDataSet" msprop:Generator_UserDSName="SIS_DBDataSet">
1447 <xs:complexType>
1448 <xs:choice minOccurs="0" maxOccurs="unbounded">
1449 <xs:element name="Activation" msprop:Generator_TableClassName="ActivationDataTable" msprop:Generator_TableVarName="tableActivation" msprop:Generator_TablePropName="Activation" msprop:Generator_RowDeletingName="ActivationRowDeleting" msprop:Generator_RowChangingName="ActivationRowChanging" msprop:Generator_RowEvHandlerName="ActivationRowChangeEventHandler" msprop:Generator_RowDeletedName="ActivationRowDeleted" msprop:Generator_UserTableName="Activation" msprop:Generator_RowChangedName="ActivationRowChanged" msprop:Generator_RowEvArgName="ActivationRowChangeEvent" msprop:Generator_RowClassName="ActivationRow">
1450 <xs:complexType>
1451 <xs:sequence>
1452 <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
1453 <xs:element name="HardwareID" msprop:Generator_ColumnVarNameInTable="columnHardwareID" msprop:Generator_ColumnPropNameInRow="HardwareID" msprop:Generator_ColumnPropNameInTable="HardwareIDColumn" msprop:Generator_UserColumnName="HardwareID">
1454 <xs:simpleType>
1455 <xs:restriction base="xs:string">
1456 <xs:maxLength value="100" />
1457 </xs:restriction>
1458 </xs:simpleType>
1459 </xs:element>
1460 <xs:element name="SerialNo" msprop:Generator_ColumnVarNameInTable="columnSerialNo" msprop:Generator_ColumnPropNameInRow="SerialNo" msprop:Generator_ColumnPropNameInTable="SerialNoColumn" msprop:Generator_UserColumnName="SerialNo">
1461 <xs:simpleType>
1462 <xs:restriction base="xs:string">
1463 <xs:maxLength value="100" />
1464 </xs:restriction>
1465 </xs:simpleType>
1466 </xs:element>
1467 <xs:element name="ActivationID" msprop:Generator_ColumnVarNameInTable="columnActivationID" msprop:Generator_ColumnPropNameInRow="ActivationID" msprop:Generator_ColumnPropNameInTable="ActivationIDColumn" msprop:Generator_UserColumnName="ActivationID">
1468 <xs:simpleType>
1469 <xs:restriction base="xs:string">
1470 <xs:maxLength value="150" />
1471 </xs:restriction>
1472 </xs:simpleType>
1473 </xs:element>
1474 </xs:sequence>
1475 </xs:complexType>
1476 </xs:element>
1477 <xs:element name="Category" msprop:Generator_TableClassName="CategoryDataTable" msprop:Generator_TableVarName="tableCategory" msprop:Generator_TablePropName="Category" msprop:Generator_RowDeletingName="CategoryRowDeleting" msprop:Generator_RowChangingName="CategoryRowChanging" msprop:Generator_RowEvHandlerName="CategoryRowChangeEventHandler" msprop:Generator_RowDeletedName="CategoryRowDeleted" msprop:Generator_UserTableName="Category" msprop:Generator_RowChangedName="CategoryRowChanged" msprop:Generator_RowEvArgName="CategoryRowChangeEvent" msprop:Generator_RowClassName="CategoryRow">
1478 <xs:complexType>
1479 <xs:sequence>
1480 <xs:element name="CategoryName" msprop:Generator_ColumnVarNameInTable="columnCategoryName" msprop:Generator_ColumnPropNameInRow="CategoryName" msprop:Generator_ColumnPropNameInTable="CategoryNameColumn" msprop:Generator_UserColumnName="CategoryName">
1481 <xs:simpleType>
1482 <xs:restriction base="xs:string">
1483 <xs:maxLength value="150" />
1484 </xs:restriction>
1485 </xs:simpleType>
1486 </xs:element>
1487 </xs:sequence>
1488 </xs:complexType>
1489 </xs:element>
1490 <xs:element name="Company" msprop:Generator_TableClassName="CompanyDataTable" msprop:Generator_TableVarName="tableCompany" msprop:Generator_TablePropName="Company" msprop:Generator_RowDeletingName="CompanyRowDeleting" msprop:Generator_RowChangingName="CompanyRowChanging" msprop:Generator_RowEvHandlerName="CompanyRowChangeEventHandler" msprop:Generator_RowDeletedName="CompanyRowDeleted" msprop:Generator_UserTableName="Company" msprop:Generator_RowChangedName="CompanyRowChanged" msprop:Generator_RowEvArgName="CompanyRowChangeEvent" msprop:Generator_RowClassName="CompanyRow">
1491 <xs:complexType>
1492 <xs:sequence>
1493 <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
1494 <xs:element name="CompanyName" msprop:Generator_ColumnVarNameInTable="columnCompanyName" msprop:Generator_ColumnPropNameInRow="CompanyName" msprop:Generator_ColumnPropNameInTable="CompanyNameColumn" msprop:Generator_UserColumnName="CompanyName">
1495 <xs:simpleType>
1496 <xs:restriction base="xs:string">
1497 <xs:maxLength value="200" />
1498 </xs:restriction>
1499 </xs:simpleType>
1500 </xs:element>
1501 <xs:element name="Address" msprop:Generator_ColumnVarNameInTable="columnAddress" msprop:Generator_ColumnPropNameInRow="Address" msprop:Generator_ColumnPropNameInTable="AddressColumn" msprop:Generator_UserColumnName="Address">
1502 <xs:simpleType>
1503 <xs:restriction base="xs:string">
1504 <xs:maxLength value="250" />
1505 </xs:restriction>
1506 </xs:simpleType>
1507 </xs:element>
1508 <xs:element name="ContactNo" msprop:Generator_ColumnVarNameInTable="columnContactNo" msprop:Generator_ColumnPropNameInRow="ContactNo" msprop:Generator_ColumnPropNameInTable="ContactNoColumn" msprop:Generator_UserColumnName="ContactNo">
1509 <xs:simpleType>
1510 <xs:restriction base="xs:string">
1511 <xs:maxLength value="150" />
1512 </xs:restriction>
1513 </xs:simpleType>
1514 </xs:element>
1515 <xs:element name="EmailID" msprop:Generator_ColumnVarNameInTable="columnEmailID" msprop:Generator_ColumnPropNameInRow="EmailID" msprop:Generator_ColumnPropNameInTable="EmailIDColumn" msprop:Generator_UserColumnName="EmailID">
1516 <xs:simpleType>
1517 <xs:restriction base="xs:string">
1518 <xs:maxLength value="150" />
1519 </xs:restriction>
1520 </xs:simpleType>
1521 </xs:element>
1522 <xs:element name="Logo" msprop:Generator_ColumnVarNameInTable="columnLogo" msprop:Generator_ColumnPropNameInRow="Logo" msprop:Generator_ColumnPropNameInTable="LogoColumn" msprop:Generator_UserColumnName="Logo" type="xs:base64Binary" />
1523 <xs:element name="TIN" msprop:Generator_ColumnVarNameInTable="columnTIN" msprop:Generator_ColumnPropNameInRow="TIN" msprop:Generator_ColumnPropNameInTable="TINColumn" msprop:Generator_UserColumnName="TIN" minOccurs="0">
1524 <xs:simpleType>
1525 <xs:restriction base="xs:string">
1526 <xs:maxLength value="150" />
1527 </xs:restriction>
1528 </xs:simpleType>
1529 </xs:element>
1530 <xs:element name="STNo" msprop:Generator_ColumnVarNameInTable="columnSTNo" msprop:Generator_ColumnPropNameInRow="STNo" msprop:Generator_ColumnPropNameInTable="STNoColumn" msprop:Generator_UserColumnName="STNo" minOccurs="0">
1531 <xs:simpleType>
1532 <xs:restriction base="xs:string">
1533 <xs:maxLength value="150" />
1534 </xs:restriction>
1535 </xs:simpleType>
1536 </xs:element>
1537 <xs:element name="CIN" msprop:Generator_ColumnVarNameInTable="columnCIN" msprop:Generator_ColumnPropNameInRow="CIN" msprop:Generator_ColumnPropNameInTable="CINColumn" msprop:Generator_UserColumnName="CIN" minOccurs="0">
1538 <xs:simpleType>
1539 <xs:restriction base="xs:string">
1540 <xs:maxLength value="150" />
1541 </xs:restriction>
1542 </xs:simpleType>
1543 </xs:element>
1544 </xs:sequence>
1545 </xs:complexType>
1546 </xs:element>
1547 <xs:element name="Company_Contacts" msprop:Generator_TableClassName="Company_ContactsDataTable" msprop:Generator_TableVarName="tableCompany_Contacts" msprop:Generator_TablePropName="Company_Contacts" msprop:Generator_RowDeletingName="Company_ContactsRowDeleting" msprop:Generator_RowChangingName="Company_ContactsRowChanging" msprop:Generator_RowEvHandlerName="Company_ContactsRowChangeEventHandler" msprop:Generator_RowDeletedName="Company_ContactsRowDeleted" msprop:Generator_UserTableName="Company_Contacts" msprop:Generator_RowChangedName="Company_ContactsRowChanged" msprop:Generator_RowEvArgName="Company_ContactsRowChangeEvent" msprop:Generator_RowClassName="Company_ContactsRow">
1548 <xs:complexType>
1549 <xs:sequence>
1550 <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
1551 <xs:element name="ContactPerson" msprop:Generator_ColumnVarNameInTable="columnContactPerson" msprop:Generator_ColumnPropNameInRow="ContactPerson" msprop:Generator_ColumnPropNameInTable="ContactPersonColumn" msprop:Generator_UserColumnName="ContactPerson">
1552 <xs:simpleType>
1553 <xs:restriction base="xs:string">
1554 <xs:maxLength value="150" />
1555 </xs:restriction>
1556 </xs:simpleType>
1557 </xs:element>
1558 <xs:element name="ContactNo" msprop:Generator_ColumnVarNameInTable="columnContactNo" msprop:Generator_ColumnPropNameInRow="ContactNo" msprop:Generator_ColumnPropNameInTable="ContactNoColumn" msprop:Generator_UserColumnName="ContactNo">
1559 <xs:simpleType>
1560 <xs:restriction base="xs:string">
1561 <xs:maxLength value="150" />
1562 </xs:restriction>
1563 </xs:simpleType>
1564 </xs:element>
1565 </xs:sequence>
1566 </xs:complexType>
1567 </xs:element>
1568 <xs:element name="Customer" msprop:Generator_TableClassName="CustomerDataTable" msprop:Generator_TableVarName="tableCustomer" msprop:Generator_TablePropName="Customer" msprop:Generator_RowDeletingName="CustomerRowDeleting" msprop:Generator_RowChangingName="CustomerRowChanging" msprop:Generator_RowEvHandlerName="CustomerRowChangeEventHandler" msprop:Generator_RowDeletedName="CustomerRowDeleted" msprop:Generator_UserTableName="Customer" msprop:Generator_RowChangedName="CustomerRowChanged" msprop:Generator_RowEvArgName="CustomerRowChangeEvent" msprop:Generator_RowClassName="CustomerRow">
1569 <xs:complexType>
1570 <xs:sequence>
1571 <xs:element name="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
1572 <xs:element name="CustomerID" msprop:Generator_ColumnVarNameInTable="columnCustomerID" msprop:Generator_ColumnPropNameInRow="CustomerID" msprop:Generator_ColumnPropNameInTable="CustomerIDColumn" msprop:Generator_UserColumnName="CustomerID">
1573 <xs:simpleType>
1574 <xs:restriction base="xs:string">
1575 <xs:maxLength value="30" />
1576 </xs:restriction>
1577 </xs:simpleType>
1578 </xs:element>
1579 <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
1580 <xs:simpleType>
1581 <xs:restriction base="xs:string">
1582 <xs:maxLength value="200" />
1583 </xs:restriction>
1584 </xs:simpleType>
1585 </xs:element>
1586 <xs:element name="Gender" msprop:Generator_ColumnVarNameInTable="columnGender" msprop:Generator_ColumnPropNameInRow="Gender" msprop:Generator_ColumnPropNameInTable="GenderColumn" msprop:Generator_UserColumnName="Gender">
1587 <xs:simpleType>
1588 <xs:restriction base="xs:string">
1589 <xs:maxLength value="10" />
1590 </xs:restriction>
1591 </xs:simpleType>
1592 </xs:element>
1593 <xs:element name="Address" msprop:Generator_ColumnVarNameInTable="columnAddress" msprop:Generator_ColumnPropNameInRow="Address" msprop:Generator_ColumnPropNameInTable="AddressColumn" msprop:Generator_UserColumnName="Address">
1594 <xs:simpleType>
1595 <xs:restriction base="xs:string">
1596 <xs:maxLength value="250" />
1597 </xs:restriction>
1598 </xs:simpleType>
1599 </xs:element>
1600 <xs:element name="City" msprop:Generator_ColumnVarNameInTable="columnCity" msprop:Generator_ColumnPropNameInRow="City" msprop:Generator_ColumnPropNameInTable="CityColumn" msprop:Generator_UserColumnName="City">
1601 <xs:simpleType>
1602 <xs:restriction base="xs:string">
1603 <xs:maxLength value="200" />
1604 </xs:restriction>
1605 </xs:simpleType>
1606 </xs:element>
1607 <xs:element name="State" msprop:Generator_ColumnVarNameInTable="columnState" msprop:Generator_ColumnPropNameInRow="State" msprop:Generator_ColumnPropNameInTable="StateColumn" msprop:Generator_UserColumnName="State">
1608 <xs:simpleType>
1609 <xs:restriction base="xs:string">
1610 <xs:maxLength value="150" />
1611 </xs:restriction>
1612 </xs:simpleType>
1613 </xs:element>
1614 <xs:element name="ZipCode" msprop:Generator_ColumnVarNameInTable="columnZipCode" msprop:Generator_ColumnPropNameInRow="ZipCode" msprop:Generator_ColumnPropNameInTable="ZipCodeColumn" msprop:Generator_UserColumnName="ZipCode" minOccurs="0">
1615 <xs:simpleType>
1616 <xs:restriction base="xs:string">
1617 <xs:maxLength value="15" />
1618 </xs:restriction>
1619 </xs:simpleType>
1620 </xs:element>
1621 <xs:element name="ContactNo" msprop:Generator_ColumnVarNameInTable="columnContactNo" msprop:Generator_ColumnPropNameInRow="ContactNo" msprop:Generator_ColumnPropNameInTable="ContactNoColumn" msprop:Generator_UserColumnName="ContactNo">
1622 <xs:simpleType>
1623 <xs:restriction base="xs:string">
1624 <xs:maxLength value="150" />
1625 </xs:restriction>
1626 </xs:simpleType>
1627 </xs:element>
1628 <xs:element name="EmailID" msprop:Generator_ColumnVarNameInTable="columnEmailID" msprop:Generator_ColumnPropNameInRow="EmailID" msprop:Generator_ColumnPropNameInTable="EmailIDColumn" msprop:Generator_UserColumnName="EmailID" minOccurs="0">
1629 <xs:simpleType>
1630 <xs:restriction base="xs:string">
1631 <xs:maxLength value="200" />
1632 </xs:restriction>
1633 </xs:simpleType>
1634 </xs:element>
1635 <xs:element name="Remarks" msprop:Generator_ColumnVarNameInTable="columnRemarks" msprop:Generator_ColumnPropNameInRow="Remarks" msprop:Generator_ColumnPropNameInTable="RemarksColumn" msprop:Generator_UserColumnName="Remarks" minOccurs="0">
1636 <xs:simpleType>
1637 <xs:restriction base="xs:string">
1638 <xs:maxLength value="2147483647" />
1639 </xs:restriction>
1640 </xs:simpleType>
1641 </xs:element>
1642 <xs:element name="Photo" msprop:Generator_ColumnVarNameInTable="columnPhoto" msprop:Generator_ColumnPropNameInRow="Photo" msprop:Generator_ColumnPropNameInTable="PhotoColumn" msprop:Generator_UserColumnName="Photo" type="xs:base64Binary" />
1643 </xs:sequence>
1644 </xs:complexType>
1645 </xs:element>
1646 <xs:element name="Invoice_Payment" msprop:Generator_TableClassName="Invoice_PaymentDataTable" msprop:Generator_TableVarName="tableInvoice_Payment" msprop:Generator_TablePropName="Invoice_Payment" msprop:Generator_RowDeletingName="Invoice_PaymentRowDeleting" msprop:Generator_RowChangingName="Invoice_PaymentRowChanging" msprop:Generator_RowEvHandlerName="Invoice_PaymentRowChangeEventHandler" msprop:Generator_RowDeletedName="Invoice_PaymentRowDeleted" msprop:Generator_UserTableName="Invoice_Payment" msprop:Generator_RowChangedName="Invoice_PaymentRowChanged" msprop:Generator_RowEvArgName="Invoice_PaymentRowChangeEvent" msprop:Generator_RowClassName="Invoice_PaymentRow">
1647 <xs:complexType>
1648 <xs:sequence>
1649 <xs:element name="IP_ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIP_ID" msprop:Generator_ColumnPropNameInRow="IP_ID" msprop:Generator_ColumnPropNameInTable="IP_IDColumn" msprop:Generator_UserColumnName="IP_ID" type="xs:int" />
1650 <xs:element name="InvoiceID" msprop:Generator_ColumnVarNameInTable="columnInvoiceID" msprop:Generator_ColumnPropNameInRow="InvoiceID" msprop:Generator_ColumnPropNameInTable="InvoiceIDColumn" msprop:Generator_UserColumnName="InvoiceID" type="xs:int" />
1651 <xs:element name="PaymentDate" msprop:Generator_ColumnVarNameInTable="columnPaymentDate" msprop:Generator_ColumnPropNameInRow="PaymentDate" msprop:Generator_ColumnPropNameInTable="PaymentDateColumn" msprop:Generator_UserColumnName="PaymentDate" type="xs:dateTime" />
1652 <xs:element name="TotalPaid" msprop:Generator_ColumnVarNameInTable="columnTotalPaid" msprop:Generator_ColumnPropNameInRow="TotalPaid" msprop:Generator_ColumnPropNameInTable="TotalPaidColumn" msprop:Generator_UserColumnName="TotalPaid" type="xs:decimal" />
1653 <xs:element name="PaymentMode" msprop:Generator_ColumnVarNameInTable="columnPaymentMode" msprop:Generator_ColumnPropNameInRow="PaymentMode" msprop:Generator_ColumnPropNameInTable="PaymentModeColumn" msprop:Generator_UserColumnName="PaymentMode">
1654 <xs:simpleType>
1655 <xs:restriction base="xs:string">
1656 <xs:maxLength value="150" />
1657 </xs:restriction>
1658 </xs:simpleType>
1659 </xs:element>
1660 </xs:sequence>
1661 </xs:complexType>
1662 </xs:element>
1663 <xs:element name="Invoice_Product" msprop:Generator_TableClassName="Invoice_ProductDataTable" msprop:Generator_TableVarName="tableInvoice_Product" msprop:Generator_TablePropName="Invoice_Product" msprop:Generator_RowDeletingName="Invoice_ProductRowDeleting" msprop:Generator_RowChangingName="Invoice_ProductRowChanging" msprop:Generator_RowEvHandlerName="Invoice_ProductRowChangeEventHandler" msprop:Generator_RowDeletedName="Invoice_ProductRowDeleted" msprop:Generator_UserTableName="Invoice_Product" msprop:Generator_RowChangedName="Invoice_ProductRowChanged" msprop:Generator_RowEvArgName="Invoice_ProductRowChangeEvent" msprop:Generator_RowClassName="Invoice_ProductRow">
1664 <xs:complexType>
1665 <xs:sequence>
1666 <xs:element name="IPo_ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIPo_ID" msprop:Generator_ColumnPropNameInRow="IPo_ID" msprop:Generator_ColumnPropNameInTable="IPo_IDColumn" msprop:Generator_UserColumnName="IPo_ID" type="xs:int" />
1667 <xs:element name="InvoiceID" msprop:Generator_ColumnVarNameInTable="columnInvoiceID" msprop:Generator_ColumnPropNameInRow="InvoiceID" msprop:Generator_ColumnPropNameInTable="InvoiceIDColumn" msprop:Generator_UserColumnName="InvoiceID" type="xs:int" />
1668 <xs:element name="ProductID" msprop:Generator_ColumnVarNameInTable="columnProductID" msprop:Generator_ColumnPropNameInRow="ProductID" msprop:Generator_ColumnPropNameInTable="ProductIDColumn" msprop:Generator_UserColumnName="ProductID" type="xs:int" />
1669 <xs:element name="CostPrice" msprop:Generator_ColumnVarNameInTable="columnCostPrice" msprop:Generator_ColumnPropNameInRow="CostPrice" msprop:Generator_ColumnPropNameInTable="CostPriceColumn" msprop:Generator_UserColumnName="CostPrice" type="xs:decimal" />
1670 <xs:element name="SellingPrice" msprop:Generator_ColumnVarNameInTable="columnSellingPrice" msprop:Generator_ColumnPropNameInRow="SellingPrice" msprop:Generator_ColumnPropNameInTable="SellingPriceColumn" msprop:Generator_UserColumnName="SellingPrice" type="xs:decimal" />
1671 <xs:element name="Margin" msprop:Generator_ColumnVarNameInTable="columnMargin" msprop:Generator_ColumnPropNameInRow="Margin" msprop:Generator_ColumnPropNameInTable="MarginColumn" msprop:Generator_UserColumnName="Margin" type="xs:decimal" />
1672 <xs:element name="Qty" msprop:Generator_ColumnVarNameInTable="columnQty" msprop:Generator_ColumnPropNameInRow="Qty" msprop:Generator_ColumnPropNameInTable="QtyColumn" msprop:Generator_UserColumnName="Qty" type="xs:int" />
1673 <xs:element name="Amount" msprop:Generator_ColumnVarNameInTable="columnAmount" msprop:Generator_ColumnPropNameInRow="Amount" msprop:Generator_ColumnPropNameInTable="AmountColumn" msprop:Generator_UserColumnName="Amount" type="xs:decimal" />
1674 <xs:element name="DiscountPer" msprop:Generator_ColumnVarNameInTable="columnDiscountPer" msprop:Generator_ColumnPropNameInRow="DiscountPer" msprop:Generator_ColumnPropNameInTable="DiscountPerColumn" msprop:Generator_UserColumnName="DiscountPer" type="xs:decimal" />
1675 <xs:element name="Discount" msprop:Generator_ColumnVarNameInTable="columnDiscount" msprop:Generator_ColumnPropNameInRow="Discount" msprop:Generator_ColumnPropNameInTable="DiscountColumn" msprop:Generator_UserColumnName="Discount" type="xs:decimal" />
1676 <xs:element name="VATPer" msprop:Generator_ColumnVarNameInTable="columnVATPer" msprop:Generator_ColumnPropNameInRow="VATPer" msprop:Generator_ColumnPropNameInTable="VATPerColumn" msprop:Generator_UserColumnName="VATPer" type="xs:decimal" />
1677 <xs:element name="VAT" msprop:Generator_ColumnVarNameInTable="columnVAT" msprop:Generator_ColumnPropNameInRow="VAT" msprop:Generator_ColumnPropNameInTable="VATColumn" msprop:Generator_UserColumnName="VAT" type="xs:decimal" />
1678 <xs:element name="TotalAmount" msprop:Generator_ColumnVarNameInTable="columnTotalAmount" msprop:Generator_ColumnPropNameInRow="TotalAmount" msprop:Generator_ColumnPropNameInTable="TotalAmountColumn" msprop:Generator_UserColumnName="TotalAmount" type="xs:decimal" />
1679 </xs:sequence>
1680 </xs:complexType>
1681 </xs:element>
1682 <xs:element name="InvoiceInfo" msprop:Generator_TableClassName="InvoiceInfoDataTable" msprop:Generator_TableVarName="tableInvoiceInfo" msprop:Generator_TablePropName="InvoiceInfo" msprop:Generator_RowDeletingName="InvoiceInfoRowDeleting" msprop:Generator_RowChangingName="InvoiceInfoRowChanging" msprop:Generator_RowEvHandlerName="InvoiceInfoRowChangeEventHandler" msprop:Generator_RowDeletedName="InvoiceInfoRowDeleted" msprop:Generator_UserTableName="InvoiceInfo" msprop:Generator_RowChangedName="InvoiceInfoRowChanged" msprop:Generator_RowEvArgName="InvoiceInfoRowChangeEvent" msprop:Generator_RowClassName="InvoiceInfoRow">
1683 <xs:complexType>
1684 <xs:sequence>
1685 <xs:element name="Inv_ID" msprop:Generator_ColumnVarNameInTable="columnInv_ID" msprop:Generator_ColumnPropNameInRow="Inv_ID" msprop:Generator_ColumnPropNameInTable="Inv_IDColumn" msprop:Generator_UserColumnName="Inv_ID" type="xs:int" />
1686 <xs:element name="InvoiceNo" msprop:Generator_ColumnVarNameInTable="columnInvoiceNo" msprop:Generator_ColumnPropNameInRow="InvoiceNo" msprop:Generator_ColumnPropNameInTable="InvoiceNoColumn" msprop:Generator_UserColumnName="InvoiceNo">
1687 <xs:simpleType>
1688 <xs:restriction base="xs:string">
1689 <xs:maxLength value="30" />
1690 </xs:restriction>
1691 </xs:simpleType>
1692 </xs:element>
1693 <xs:element name="InvoiceDate" msprop:Generator_ColumnVarNameInTable="columnInvoiceDate" msprop:Generator_ColumnPropNameInRow="InvoiceDate" msprop:Generator_ColumnPropNameInTable="InvoiceDateColumn" msprop:Generator_UserColumnName="InvoiceDate" type="xs:dateTime" />
1694 <xs:element name="CustomerID" msprop:Generator_ColumnVarNameInTable="columnCustomerID" msprop:Generator_ColumnPropNameInRow="CustomerID" msprop:Generator_ColumnPropNameInTable="CustomerIDColumn" msprop:Generator_UserColumnName="CustomerID" type="xs:int" />
1695 <xs:element name="GrandTotal" msprop:Generator_ColumnVarNameInTable="columnGrandTotal" msprop:Generator_ColumnPropNameInRow="GrandTotal" msprop:Generator_ColumnPropNameInTable="GrandTotalColumn" msprop:Generator_UserColumnName="GrandTotal" type="xs:decimal" />
1696 <xs:element name="TotalPaid" msprop:Generator_ColumnVarNameInTable="columnTotalPaid" msprop:Generator_ColumnPropNameInRow="TotalPaid" msprop:Generator_ColumnPropNameInTable="TotalPaidColumn" msprop:Generator_UserColumnName="TotalPaid" type="xs:decimal" />
1697 <xs:element name="Balance" msprop:Generator_ColumnVarNameInTable="columnBalance" msprop:Generator_ColumnPropNameInRow="Balance" msprop:Generator_ColumnPropNameInTable="BalanceColumn" msprop:Generator_UserColumnName="Balance" type="xs:decimal" />
1698 <xs:element name="Remarks" msprop:Generator_ColumnVarNameInTable="columnRemarks" msprop:Generator_ColumnPropNameInRow="Remarks" msprop:Generator_ColumnPropNameInTable="RemarksColumn" msprop:Generator_UserColumnName="Remarks" minOccurs="0">
1699 <xs:simpleType>
1700 <xs:restriction base="xs:string">
1701 <xs:maxLength value="2147483647" />
1702 </xs:restriction>
1703 </xs:simpleType>
1704 </xs:element>
1705 </xs:sequence>
1706 </xs:complexType>
1707 </xs:element>
1708 <xs:element name="Logs" msprop:Generator_TableClassName="LogsDataTable" msprop:Generator_TableVarName="tableLogs" msprop:Generator_TablePropName="Logs" msprop:Generator_RowDeletingName="LogsRowDeleting" msprop:Generator_RowChangingName="LogsRowChanging" msprop:Generator_RowEvHandlerName="LogsRowChangeEventHandler" msprop:Generator_RowDeletedName="LogsRowDeleted" msprop:Generator_UserTableName="Logs" msprop:Generator_RowChangedName="LogsRowChanged" msprop:Generator_RowEvArgName="LogsRowChangeEvent" msprop:Generator_RowClassName="LogsRow">
1709 <xs:complexType>
1710 <xs:sequence>
1711 <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
1712 <xs:element name="UserID" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" msprop:Generator_UserColumnName="UserID">
1713 <xs:simpleType>
1714 <xs:restriction base="xs:string">
1715 <xs:maxLength value="100" />
1716 </xs:restriction>
1717 </xs:simpleType>
1718 </xs:element>
1719 <xs:element name="Operation" msprop:Generator_ColumnVarNameInTable="columnOperation" msprop:Generator_ColumnPropNameInRow="Operation" msprop:Generator_ColumnPropNameInTable="OperationColumn" msprop:Generator_UserColumnName="Operation">
1720 <xs:simpleType>
1721 <xs:restriction base="xs:string">
1722 <xs:maxLength value="2147483647" />
1723 </xs:restriction>
1724 </xs:simpleType>
1725 </xs:element>
1726 <xs:element name="Date" msprop:Generator_ColumnVarNameInTable="columnDate" msprop:Generator_ColumnPropNameInRow="_Date" msprop:Generator_ColumnPropNameInTable="DateColumn" msprop:Generator_UserColumnName="Date" type="xs:dateTime" />
1727 </xs:sequence>
1728 </xs:complexType>
1729 </xs:element>
1730 <xs:element name="Product" msprop:Generator_TableClassName="ProductDataTable" msprop:Generator_TableVarName="tableProduct" msprop:Generator_TablePropName="Product" msprop:Generator_RowDeletingName="ProductRowDeleting" msprop:Generator_RowChangingName="ProductRowChanging" msprop:Generator_RowEvHandlerName="ProductRowChangeEventHandler" msprop:Generator_RowDeletedName="ProductRowDeleted" msprop:Generator_UserTableName="Product" msprop:Generator_RowChangedName="ProductRowChanged" msprop:Generator_RowEvArgName="ProductRowChangeEvent" msprop:Generator_RowClassName="ProductRow">
1731 <xs:complexType>
1732 <xs:sequence>
1733 <xs:element name="PID" msprop:Generator_ColumnVarNameInTable="columnPID" msprop:Generator_ColumnPropNameInRow="PID" msprop:Generator_ColumnPropNameInTable="PIDColumn" msprop:Generator_UserColumnName="PID" type="xs:int" />
1734 <xs:element name="ProductCode" msprop:Generator_ColumnVarNameInTable="columnProductCode" msprop:Generator_ColumnPropNameInRow="ProductCode" msprop:Generator_ColumnPropNameInTable="ProductCodeColumn" msprop:Generator_UserColumnName="ProductCode">
1735 <xs:simpleType>
1736 <xs:restriction base="xs:string">
1737 <xs:maxLength value="30" />
1738 </xs:restriction>
1739 </xs:simpleType>
1740 </xs:element>
1741 <xs:element name="ProductName" msprop:Generator_ColumnVarNameInTable="columnProductName" msprop:Generator_ColumnPropNameInRow="ProductName" msprop:Generator_ColumnPropNameInTable="ProductNameColumn" msprop:Generator_UserColumnName="ProductName">
1742 <xs:simpleType>
1743 <xs:restriction base="xs:string">
1744 <xs:maxLength value="200" />
1745 </xs:restriction>
1746 </xs:simpleType>
1747 </xs:element>
1748 <xs:element name="SubCategoryID" msprop:Generator_ColumnVarNameInTable="columnSubCategoryID" msprop:Generator_ColumnPropNameInRow="SubCategoryID" msprop:Generator_ColumnPropNameInTable="SubCategoryIDColumn" msprop:Generator_UserColumnName="SubCategoryID" type="xs:int" />
1749 <xs:element name="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" msprop:Generator_UserColumnName="Description" minOccurs="0">
1750 <xs:simpleType>
1751 <xs:restriction base="xs:string">
1752 <xs:maxLength value="2147483647" />
1753 </xs:restriction>
1754 </xs:simpleType>
1755 </xs:element>
1756 <xs:element name="CostPrice" msprop:Generator_ColumnVarNameInTable="columnCostPrice" msprop:Generator_ColumnPropNameInRow="CostPrice" msprop:Generator_ColumnPropNameInTable="CostPriceColumn" msprop:Generator_UserColumnName="CostPrice" type="xs:decimal" />
1757 <xs:element name="SellingPrice" msprop:Generator_ColumnVarNameInTable="columnSellingPrice" msprop:Generator_ColumnPropNameInRow="SellingPrice" msprop:Generator_ColumnPropNameInTable="SellingPriceColumn" msprop:Generator_UserColumnName="SellingPrice" type="xs:decimal" />
1758 <xs:element name="Discount" msprop:Generator_ColumnVarNameInTable="columnDiscount" msprop:Generator_ColumnPropNameInRow="Discount" msprop:Generator_ColumnPropNameInTable="DiscountColumn" msprop:Generator_UserColumnName="Discount" type="xs:decimal" />
1759 <xs:element name="VAT" msprop:Generator_ColumnVarNameInTable="columnVAT" msprop:Generator_ColumnPropNameInRow="VAT" msprop:Generator_ColumnPropNameInTable="VATColumn" msprop:Generator_UserColumnName="VAT" type="xs:decimal" />
1760 <xs:element name="ReorderPoint" msprop:Generator_ColumnVarNameInTable="columnReorderPoint" msprop:Generator_ColumnPropNameInRow="ReorderPoint" msprop:Generator_ColumnPropNameInTable="ReorderPointColumn" msprop:Generator_UserColumnName="ReorderPoint" type="xs:int" />
1761 </xs:sequence>
1762 </xs:complexType>
1763 </xs:element>
1764 <xs:element name="Product_Join" msprop:Generator_TableClassName="Product_JoinDataTable" msprop:Generator_TableVarName="tableProduct_Join" msprop:Generator_TablePropName="Product_Join" msprop:Generator_RowDeletingName="Product_JoinRowDeleting" msprop:Generator_RowChangingName="Product_JoinRowChanging" msprop:Generator_RowEvHandlerName="Product_JoinRowChangeEventHandler" msprop:Generator_RowDeletedName="Product_JoinRowDeleted" msprop:Generator_UserTableName="Product_Join" msprop:Generator_RowChangedName="Product_JoinRowChanged" msprop:Generator_RowEvArgName="Product_JoinRowChangeEvent" msprop:Generator_RowClassName="Product_JoinRow">
1765 <xs:complexType>
1766 <xs:sequence>
1767 <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
1768 <xs:element name="ProductID" msprop:Generator_ColumnVarNameInTable="columnProductID" msprop:Generator_ColumnPropNameInRow="ProductID" msprop:Generator_ColumnPropNameInTable="ProductIDColumn" msprop:Generator_UserColumnName="ProductID" type="xs:int" />
1769 <xs:element name="Photo" msprop:Generator_ColumnVarNameInTable="columnPhoto" msprop:Generator_ColumnPropNameInRow="Photo" msprop:Generator_ColumnPropNameInTable="PhotoColumn" msprop:Generator_UserColumnName="Photo" type="xs:base64Binary" />
1770 </xs:sequence>
1771 </xs:complexType>
1772 </xs:element>
1773 <xs:element name="Quotation" msprop:Generator_TableClassName="QuotationDataTable" msprop:Generator_TableVarName="tableQuotation" msprop:Generator_TablePropName="Quotation" msprop:Generator_RowDeletingName="QuotationRowDeleting" msprop:Generator_RowChangingName="QuotationRowChanging" msprop:Generator_RowEvHandlerName="QuotationRowChangeEventHandler" msprop:Generator_RowDeletedName="QuotationRowDeleted" msprop:Generator_UserTableName="Quotation" msprop:Generator_RowChangedName="QuotationRowChanged" msprop:Generator_RowEvArgName="QuotationRowChangeEvent" msprop:Generator_RowClassName="QuotationRow">
1774 <xs:complexType>
1775 <xs:sequence>
1776 <xs:element name="Q_ID" msprop:Generator_ColumnVarNameInTable="columnQ_ID" msprop:Generator_ColumnPropNameInRow="Q_ID" msprop:Generator_ColumnPropNameInTable="Q_IDColumn" msprop:Generator_UserColumnName="Q_ID" type="xs:int" />
1777 <xs:element name="QuotationNo" msprop:Generator_ColumnVarNameInTable="columnQuotationNo" msprop:Generator_ColumnPropNameInRow="QuotationNo" msprop:Generator_ColumnPropNameInTable="QuotationNoColumn" msprop:Generator_UserColumnName="QuotationNo">
1778 <xs:simpleType>
1779 <xs:restriction base="xs:string">
1780 <xs:maxLength value="30" />
1781 </xs:restriction>
1782 </xs:simpleType>
1783 </xs:element>
1784 <xs:element name="Date" msprop:Generator_ColumnVarNameInTable="columnDate" msprop:Generator_ColumnPropNameInRow="_Date" msprop:Generator_ColumnPropNameInTable="DateColumn" msprop:Generator_UserColumnName="Date" type="xs:dateTime" />
1785 <xs:element name="CustomerID" msprop:Generator_ColumnVarNameInTable="columnCustomerID" msprop:Generator_ColumnPropNameInRow="CustomerID" msprop:Generator_ColumnPropNameInTable="CustomerIDColumn" msprop:Generator_UserColumnName="CustomerID" type="xs:int" />
1786 <xs:element name="GrandTotal" msprop:Generator_ColumnVarNameInTable="columnGrandTotal" msprop:Generator_ColumnPropNameInRow="GrandTotal" msprop:Generator_ColumnPropNameInTable="GrandTotalColumn" msprop:Generator_UserColumnName="GrandTotal" type="xs:decimal" />
1787 <xs:element name="Remarks" msprop:Generator_ColumnVarNameInTable="columnRemarks" msprop:Generator_ColumnPropNameInRow="Remarks" msprop:Generator_ColumnPropNameInTable="RemarksColumn" msprop:Generator_UserColumnName="Remarks" minOccurs="0">
1788 <xs:simpleType>
1789 <xs:restriction base="xs:string">
1790 <xs:maxLength value="2147483647" />
1791 </xs:restriction>
1792 </xs:simpleType>
1793 </xs:element>
1794 </xs:sequence>
1795 </xs:complexType>
1796 </xs:element>
1797 <xs:element name="Quotation_Join" msprop:Generator_TableClassName="Quotation_JoinDataTable" msprop:Generator_TableVarName="tableQuotation_Join" msprop:Generator_TablePropName="Quotation_Join" msprop:Generator_RowDeletingName="Quotation_JoinRowDeleting" msprop:Generator_RowChangingName="Quotation_JoinRowChanging" msprop:Generator_RowEvHandlerName="Quotation_JoinRowChangeEventHandler" msprop:Generator_RowDeletedName="Quotation_JoinRowDeleted" msprop:Generator_UserTableName="Quotation_Join" msprop:Generator_RowChangedName="Quotation_JoinRowChanged" msprop:Generator_RowEvArgName="Quotation_JoinRowChangeEvent" msprop:Generator_RowClassName="Quotation_JoinRow">
1798 <xs:complexType>
1799 <xs:sequence>
1800 <xs:element name="QJ_ID" msprop:Generator_ColumnVarNameInTable="columnQJ_ID" msprop:Generator_ColumnPropNameInRow="QJ_ID" msprop:Generator_ColumnPropNameInTable="QJ_IDColumn" msprop:Generator_UserColumnName="QJ_ID" type="xs:int" />
1801 <xs:element name="QuotationID" msprop:Generator_ColumnVarNameInTable="columnQuotationID" msprop:Generator_ColumnPropNameInRow="QuotationID" msprop:Generator_ColumnPropNameInTable="QuotationIDColumn" msprop:Generator_UserColumnName="QuotationID" type="xs:int" />
1802 <xs:element name="ProductID" msprop:Generator_ColumnVarNameInTable="columnProductID" msprop:Generator_ColumnPropNameInRow="ProductID" msprop:Generator_ColumnPropNameInTable="ProductIDColumn" msprop:Generator_UserColumnName="ProductID" type="xs:int" />
1803 <xs:element name="Cost" msprop:Generator_ColumnVarNameInTable="columnCost" msprop:Generator_ColumnPropNameInRow="Cost" msprop:Generator_ColumnPropNameInTable="CostColumn" msprop:Generator_UserColumnName="Cost" type="xs:decimal" />
1804 <xs:element name="Qty" msprop:Generator_ColumnVarNameInTable="columnQty" msprop:Generator_ColumnPropNameInRow="Qty" msprop:Generator_ColumnPropNameInTable="QtyColumn" msprop:Generator_UserColumnName="Qty" type="xs:int" />
1805 <xs:element name="Amount" msprop:Generator_ColumnVarNameInTable="columnAmount" msprop:Generator_ColumnPropNameInRow="Amount" msprop:Generator_ColumnPropNameInTable="AmountColumn" msprop:Generator_UserColumnName="Amount" type="xs:decimal" />
1806 <xs:element name="DiscountPer" msprop:Generator_ColumnVarNameInTable="columnDiscountPer" msprop:Generator_ColumnPropNameInRow="DiscountPer" msprop:Generator_ColumnPropNameInTable="DiscountPerColumn" msprop:Generator_UserColumnName="DiscountPer" type="xs:decimal" />
1807 <xs:element name="Discount" msprop:Generator_ColumnVarNameInTable="columnDiscount" msprop:Generator_ColumnPropNameInRow="Discount" msprop:Generator_ColumnPropNameInTable="DiscountColumn" msprop:Generator_UserColumnName="Discount" type="xs:decimal" />
1808 <xs:element name="VATPer" msprop:Generator_ColumnVarNameInTable="columnVATPer" msprop:Generator_ColumnPropNameInRow="VATPer" msprop:Generator_ColumnPropNameInTable="VATPerColumn" msprop:Generator_UserColumnName="VATPer" type="xs:decimal" />
1809 <xs:element name="VAT" msprop:Generator_ColumnVarNameInTable="columnVAT" msprop:Generator_ColumnPropNameInRow="VAT" msprop:Generator_ColumnPropNameInTable="VATColumn" msprop:Generator_UserColumnName="VAT" type="xs:decimal" />
1810 <xs:element name="TotalAmount" msprop:Generator_ColumnVarNameInTable="columnTotalAmount" msprop:Generator_ColumnPropNameInRow="TotalAmount" msprop:Generator_ColumnPropNameInTable="TotalAmountColumn" msprop:Generator_UserColumnName="TotalAmount" type="xs:decimal" />
1811 </xs:sequence>
1812 </xs:complexType>
1813 </xs:element>
1814 <xs:element name="Registration" msprop:Generator_TableClassName="RegistrationDataTable" msprop:Generator_TableVarName="tableRegistration" msprop:Generator_TablePropName="Registration" msprop:Generator_RowDeletingName="RegistrationRowDeleting" msprop:Generator_RowChangingName="RegistrationRowChanging" msprop:Generator_RowEvHandlerName="RegistrationRowChangeEventHandler" msprop:Generator_RowDeletedName="RegistrationRowDeleted" msprop:Generator_UserTableName="Registration" msprop:Generator_RowChangedName="RegistrationRowChanged" msprop:Generator_RowEvArgName="RegistrationRowChangeEvent" msprop:Generator_RowClassName="RegistrationRow">
1815 <xs:complexType>
1816 <xs:sequence>
1817 <xs:element name="UserID" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" msprop:Generator_UserColumnName="UserID">
1818 <xs:simpleType>
1819 <xs:restriction base="xs:string">
1820 <xs:maxLength value="100" />
1821 </xs:restriction>
1822 </xs:simpleType>
1823 </xs:element>
1824 <xs:element name="UserType" msprop:Generator_ColumnVarNameInTable="columnUserType" msprop:Generator_ColumnPropNameInRow="UserType" msprop:Generator_ColumnPropNameInTable="UserTypeColumn" msprop:Generator_UserColumnName="UserType">
1825 <xs:simpleType>
1826 <xs:restriction base="xs:string">
1827 <xs:maxLength value="150" />
1828 </xs:restriction>
1829 </xs:simpleType>
1830 </xs:element>
1831 <xs:element name="Password" msprop:Generator_ColumnVarNameInTable="columnPassword" msprop:Generator_ColumnPropNameInRow="Password" msprop:Generator_ColumnPropNameInTable="PasswordColumn" msprop:Generator_UserColumnName="Password">
1832 <xs:simpleType>
1833 <xs:restriction base="xs:string">
1834 <xs:maxLength value="100" />
1835 </xs:restriction>
1836 </xs:simpleType>
1837 </xs:element>
1838 <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
1839 <xs:simpleType>
1840 <xs:restriction base="xs:string">
1841 <xs:maxLength value="200" />
1842 </xs:restriction>
1843 </xs:simpleType>
1844 </xs:element>
1845 <xs:element name="ContactNo" msprop:Generator_ColumnVarNameInTable="columnContactNo" msprop:Generator_ColumnPropNameInRow="ContactNo" msprop:Generator_ColumnPropNameInTable="ContactNoColumn" msprop:Generator_UserColumnName="ContactNo">
1846 <xs:simpleType>
1847 <xs:restriction base="xs:string">
1848 <xs:maxLength value="150" />
1849 </xs:restriction>
1850 </xs:simpleType>
1851 </xs:element>
1852 <xs:element name="EmailID" msprop:Generator_ColumnVarNameInTable="columnEmailID" msprop:Generator_ColumnPropNameInRow="EmailID" msprop:Generator_ColumnPropNameInTable="EmailIDColumn" msprop:Generator_UserColumnName="EmailID" minOccurs="0">
1853 <xs:simpleType>
1854 <xs:restriction base="xs:string">
1855 <xs:maxLength value="200" />
1856 </xs:restriction>
1857 </xs:simpleType>
1858 </xs:element>
1859 <xs:element name="JoiningDate" msprop:Generator_ColumnVarNameInTable="columnJoiningDate" msprop:Generator_ColumnPropNameInRow="JoiningDate" msprop:Generator_ColumnPropNameInTable="JoiningDateColumn" msprop:Generator_UserColumnName="JoiningDate" type="xs:dateTime" minOccurs="0" />
1860 </xs:sequence>
1861 </xs:complexType>
1862 </xs:element>
1863 <xs:element name="Service" msprop:Generator_TableClassName="ServiceDataTable" msprop:Generator_TableVarName="tableService" msprop:Generator_TablePropName="Service" msprop:Generator_RowDeletingName="ServiceRowDeleting" msprop:Generator_RowChangingName="ServiceRowChanging" msprop:Generator_RowEvHandlerName="ServiceRowChangeEventHandler" msprop:Generator_RowDeletedName="ServiceRowDeleted" msprop:Generator_UserTableName="Service" msprop:Generator_RowChangedName="ServiceRowChanged" msprop:Generator_RowEvArgName="ServiceRowChangeEvent" msprop:Generator_RowClassName="ServiceRow">
1864 <xs:complexType>
1865 <xs:sequence>
1866 <xs:element name="S_ID" msprop:Generator_ColumnVarNameInTable="columnS_ID" msprop:Generator_ColumnPropNameInRow="S_ID" msprop:Generator_ColumnPropNameInTable="S_IDColumn" msprop:Generator_UserColumnName="S_ID" type="xs:int" />
1867 <xs:element name="ServiceCode" msprop:Generator_ColumnVarNameInTable="columnServiceCode" msprop:Generator_ColumnPropNameInRow="ServiceCode" msprop:Generator_ColumnPropNameInTable="ServiceCodeColumn" msprop:Generator_UserColumnName="ServiceCode">
1868 <xs:simpleType>
1869 <xs:restriction base="xs:string">
1870 <xs:maxLength value="30" />
1871 </xs:restriction>
1872 </xs:simpleType>
1873 </xs:element>
1874 <xs:element name="CustomerID" msprop:Generator_ColumnVarNameInTable="columnCustomerID" msprop:Generator_ColumnPropNameInRow="CustomerID" msprop:Generator_ColumnPropNameInTable="CustomerIDColumn" msprop:Generator_UserColumnName="CustomerID" type="xs:int" />
1875 <xs:element name="ServiceType" msprop:Generator_ColumnVarNameInTable="columnServiceType" msprop:Generator_ColumnPropNameInRow="ServiceType" msprop:Generator_ColumnPropNameInTable="ServiceTypeColumn" msprop:Generator_UserColumnName="ServiceType" minOccurs="0">
1876 <xs:simpleType>
1877 <xs:restriction base="xs:string">
1878 <xs:maxLength value="150" />
1879 </xs:restriction>
1880 </xs:simpleType>
1881 </xs:element>
1882 <xs:element name="ServiceCreationDate" msprop:Generator_ColumnVarNameInTable="columnServiceCreationDate" msprop:Generator_ColumnPropNameInRow="ServiceCreationDate" msprop:Generator_ColumnPropNameInTable="ServiceCreationDateColumn" msprop:Generator_UserColumnName="ServiceCreationDate" type="xs:dateTime" />
1883 <xs:element name="ItemDescription" msprop:Generator_ColumnVarNameInTable="columnItemDescription" msprop:Generator_ColumnPropNameInRow="ItemDescription" msprop:Generator_ColumnPropNameInTable="ItemDescriptionColumn" msprop:Generator_UserColumnName="ItemDescription">
1884 <xs:simpleType>
1885 <xs:restriction base="xs:string">
1886 <xs:maxLength value="2147483647" />
1887 </xs:restriction>
1888 </xs:simpleType>
1889 </xs:element>
1890 <xs:element name="ProblemDescription" msprop:Generator_ColumnVarNameInTable="columnProblemDescription" msprop:Generator_ColumnPropNameInRow="ProblemDescription" msprop:Generator_ColumnPropNameInTable="ProblemDescriptionColumn" msprop:Generator_UserColumnName="ProblemDescription" minOccurs="0">
1891 <xs:simpleType>
1892 <xs:restriction base="xs:string">
1893 <xs:maxLength value="2147483647" />
1894 </xs:restriction>
1895 </xs:simpleType>
1896 </xs:element>
1897 <xs:element name="ChargesQuote" msprop:Generator_ColumnVarNameInTable="columnChargesQuote" msprop:Generator_ColumnPropNameInRow="ChargesQuote" msprop:Generator_ColumnPropNameInTable="ChargesQuoteColumn" msprop:Generator_UserColumnName="ChargesQuote" type="xs:decimal" />
1898 <xs:element name="AdvanceDeposit" msprop:Generator_ColumnVarNameInTable="columnAdvanceDeposit" msprop:Generator_ColumnPropNameInRow="AdvanceDeposit" msprop:Generator_ColumnPropNameInTable="AdvanceDepositColumn" msprop:Generator_UserColumnName="AdvanceDeposit" type="xs:decimal" />
1899 <xs:element name="EstimatedRepairDate" msprop:Generator_ColumnVarNameInTable="columnEstimatedRepairDate" msprop:Generator_ColumnPropNameInRow="EstimatedRepairDate" msprop:Generator_ColumnPropNameInTable="EstimatedRepairDateColumn" msprop:Generator_UserColumnName="EstimatedRepairDate" type="xs:dateTime" />
1900 <xs:element name="Remarks" msprop:Generator_ColumnVarNameInTable="columnRemarks" msprop:Generator_ColumnPropNameInRow="Remarks" msprop:Generator_ColumnPropNameInTable="RemarksColumn" msprop:Generator_UserColumnName="Remarks" minOccurs="0">
1901 <xs:simpleType>
1902 <xs:restriction base="xs:string">
1903 <xs:maxLength value="2147483647" />
1904 </xs:restriction>
1905 </xs:simpleType>
1906 </xs:element>
1907 <xs:element name="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnPropNameInTable="StatusColumn" msprop:Generator_UserColumnName="Status">
1908 <xs:simpleType>
1909 <xs:restriction base="xs:string">
1910 <xs:maxLength value="30" />
1911 </xs:restriction>
1912 </xs:simpleType>
1913 </xs:element>
1914 </xs:sequence>
1915 </xs:complexType>
1916 </xs:element>
1917 <xs:element name="Stock" msprop:Generator_TableClassName="StockDataTable" msprop:Generator_TableVarName="tableStock" msprop:Generator_TablePropName="Stock" msprop:Generator_RowDeletingName="StockRowDeleting" msprop:Generator_RowChangingName="StockRowChanging" msprop:Generator_RowEvHandlerName="StockRowChangeEventHandler" msprop:Generator_RowDeletedName="StockRowDeleted" msprop:Generator_UserTableName="Stock" msprop:Generator_RowChangedName="StockRowChanged" msprop:Generator_RowEvArgName="StockRowChangeEvent" msprop:Generator_RowClassName="StockRow">
1918 <xs:complexType>
1919 <xs:sequence>
1920 <xs:element name="ST_ID" msprop:Generator_ColumnVarNameInTable="columnST_ID" msprop:Generator_ColumnPropNameInRow="ST_ID" msprop:Generator_ColumnPropNameInTable="ST_IDColumn" msprop:Generator_UserColumnName="ST_ID" type="xs:int" />
1921 <xs:element name="Stock_ID" msprop:Generator_ColumnVarNameInTable="columnStock_ID" msprop:Generator_ColumnPropNameInRow="Stock_ID" msprop:Generator_ColumnPropNameInTable="Stock_IDColumn" msprop:Generator_UserColumnName="Stock_ID">
1922 <xs:simpleType>
1923 <xs:restriction base="xs:string">
1924 <xs:maxLength value="30" />
1925 </xs:restriction>
1926 </xs:simpleType>
1927 </xs:element>
1928 <xs:element name="Date" msprop:Generator_ColumnVarNameInTable="columnDate" msprop:Generator_ColumnPropNameInRow="_Date" msprop:Generator_ColumnPropNameInTable="DateColumn" msprop:Generator_UserColumnName="Date" type="xs:dateTime" />
1929 <xs:element name="SupplierID" msprop:Generator_ColumnVarNameInTable="columnSupplierID" msprop:Generator_ColumnPropNameInRow="SupplierID" msprop:Generator_ColumnPropNameInTable="SupplierIDColumn" msprop:Generator_UserColumnName="SupplierID" type="xs:int" />
1930 <xs:element name="GrandTotal" msprop:Generator_ColumnVarNameInTable="columnGrandTotal" msprop:Generator_ColumnPropNameInRow="GrandTotal" msprop:Generator_ColumnPropNameInTable="GrandTotalColumn" msprop:Generator_UserColumnName="GrandTotal" type="xs:decimal" />
1931 <xs:element name="TotalPayment" msprop:Generator_ColumnVarNameInTable="columnTotalPayment" msprop:Generator_ColumnPropNameInRow="TotalPayment" msprop:Generator_ColumnPropNameInTable="TotalPaymentColumn" msprop:Generator_UserColumnName="TotalPayment" type="xs:decimal" />
1932 <xs:element name="PaymentDue" msprop:Generator_ColumnVarNameInTable="columnPaymentDue" msprop:Generator_ColumnPropNameInRow="PaymentDue" msprop:Generator_ColumnPropNameInTable="PaymentDueColumn" msprop:Generator_UserColumnName="PaymentDue" type="xs:decimal" />
1933 <xs:element name="Remarks" msprop:Generator_ColumnVarNameInTable="columnRemarks" msprop:Generator_ColumnPropNameInRow="Remarks" msprop:Generator_ColumnPropNameInTable="RemarksColumn" msprop:Generator_UserColumnName="Remarks" minOccurs="0">
1934 <xs:simpleType>
1935 <xs:restriction base="xs:string">
1936 <xs:maxLength value="2147483647" />
1937 </xs:restriction>
1938 </xs:simpleType>
1939 </xs:element>
1940 </xs:sequence>
1941 </xs:complexType>
1942 </xs:element>
1943 <xs:element name="Stock_Product" msprop:Generator_TableClassName="Stock_ProductDataTable" msprop:Generator_TableVarName="tableStock_Product" msprop:Generator_TablePropName="Stock_Product" msprop:Generator_RowDeletingName="Stock_ProductRowDeleting" msprop:Generator_RowChangingName="Stock_ProductRowChanging" msprop:Generator_RowEvHandlerName="Stock_ProductRowChangeEventHandler" msprop:Generator_RowDeletedName="Stock_ProductRowDeleted" msprop:Generator_UserTableName="Stock_Product" msprop:Generator_RowChangedName="Stock_ProductRowChanged" msprop:Generator_RowEvArgName="Stock_ProductRowChangeEvent" msprop:Generator_RowClassName="Stock_ProductRow">
1944 <xs:complexType>
1945 <xs:sequence>
1946 <xs:element name="SP_ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnSP_ID" msprop:Generator_ColumnPropNameInRow="SP_ID" msprop:Generator_ColumnPropNameInTable="SP_IDColumn" msprop:Generator_UserColumnName="SP_ID" type="xs:int" />
1947 <xs:element name="StockID" msprop:Generator_ColumnVarNameInTable="columnStockID" msprop:Generator_ColumnPropNameInRow="StockID" msprop:Generator_ColumnPropNameInTable="StockIDColumn" msprop:Generator_UserColumnName="StockID" type="xs:int" />
1948 <xs:element name="ProductID" msprop:Generator_ColumnVarNameInTable="columnProductID" msprop:Generator_ColumnPropNameInRow="ProductID" msprop:Generator_ColumnPropNameInTable="ProductIDColumn" msprop:Generator_UserColumnName="ProductID" type="xs:int" />
1949 <xs:element name="Qty" msprop:Generator_ColumnVarNameInTable="columnQty" msprop:Generator_ColumnPropNameInRow="Qty" msprop:Generator_ColumnPropNameInTable="QtyColumn" msprop:Generator_UserColumnName="Qty" type="xs:int" />
1950 <xs:element name="Price" msprop:Generator_ColumnVarNameInTable="columnPrice" msprop:Generator_ColumnPropNameInRow="Price" msprop:Generator_ColumnPropNameInTable="PriceColumn" msprop:Generator_UserColumnName="Price" type="xs:decimal" />
1951 <xs:element name="TotalAmount" msprop:Generator_ColumnVarNameInTable="columnTotalAmount" msprop:Generator_ColumnPropNameInRow="TotalAmount" msprop:Generator_ColumnPropNameInTable="TotalAmountColumn" msprop:Generator_UserColumnName="TotalAmount" type="xs:decimal" />
1952 </xs:sequence>
1953 </xs:complexType>
1954 </xs:element>
1955 <xs:element name="SubCategory" msprop:Generator_TableClassName="SubCategoryDataTable" msprop:Generator_TableVarName="tableSubCategory" msprop:Generator_TablePropName="SubCategory" msprop:Generator_RowDeletingName="SubCategoryRowDeleting" msprop:Generator_RowChangingName="SubCategoryRowChanging" msprop:Generator_RowEvHandlerName="SubCategoryRowChangeEventHandler" msprop:Generator_RowDeletedName="SubCategoryRowDeleted" msprop:Generator_UserTableName="SubCategory" msprop:Generator_RowChangedName="SubCategoryRowChanged" msprop:Generator_RowEvArgName="SubCategoryRowChangeEvent" msprop:Generator_RowClassName="SubCategoryRow">
1956 <xs:complexType>
1957 <xs:sequence>
1958 <xs:element name="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
1959 <xs:element name="SubCategoryName" msprop:Generator_ColumnVarNameInTable="columnSubCategoryName" msprop:Generator_ColumnPropNameInRow="SubCategoryName" msprop:Generator_ColumnPropNameInTable="SubCategoryNameColumn" msprop:Generator_UserColumnName="SubCategoryName">
1960 <xs:simpleType>
1961 <xs:restriction base="xs:string">
1962 <xs:maxLength value="150" />
1963 </xs:restriction>
1964 </xs:simpleType>
1965 </xs:element>
1966 <xs:element name="Category" msprop:Generator_ColumnVarNameInTable="columnCategory" msprop:Generator_ColumnPropNameInRow="Category" msprop:Generator_ColumnPropNameInTable="CategoryColumn" msprop:Generator_UserColumnName="Category">
1967 <xs:simpleType>
1968 <xs:restriction base="xs:string">
1969 <xs:maxLength value="150" />
1970 </xs:restriction>
1971 </xs:simpleType>
1972 </xs:element>
1973 </xs:sequence>
1974 </xs:complexType>
1975 </xs:element>
1976 <xs:element name="Supplier" msprop:Generator_TableClassName="SupplierDataTable" msprop:Generator_TableVarName="tableSupplier" msprop:Generator_TablePropName="Supplier" msprop:Generator_RowDeletingName="SupplierRowDeleting" msprop:Generator_RowChangingName="SupplierRowChanging" msprop:Generator_RowEvHandlerName="SupplierRowChangeEventHandler" msprop:Generator_RowDeletedName="SupplierRowDeleted" msprop:Generator_UserTableName="Supplier" msprop:Generator_RowChangedName="SupplierRowChanged" msprop:Generator_RowEvArgName="SupplierRowChangeEvent" msprop:Generator_RowClassName="SupplierRow">
1977 <xs:complexType>
1978 <xs:sequence>
1979 <xs:element name="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
1980 <xs:element name="SupplierID" msprop:Generator_ColumnVarNameInTable="columnSupplierID" msprop:Generator_ColumnPropNameInRow="SupplierID" msprop:Generator_ColumnPropNameInTable="SupplierIDColumn" msprop:Generator_UserColumnName="SupplierID">
1981 <xs:simpleType>
1982 <xs:restriction base="xs:string">
1983 <xs:maxLength value="30" />
1984 </xs:restriction>
1985 </xs:simpleType>
1986 </xs:element>
1987 <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
1988 <xs:simpleType>
1989 <xs:restriction base="xs:string">
1990 <xs:maxLength value="200" />
1991 </xs:restriction>
1992 </xs:simpleType>
1993 </xs:element>
1994 <xs:element name="Address" msprop:Generator_ColumnVarNameInTable="columnAddress" msprop:Generator_ColumnPropNameInRow="Address" msprop:Generator_ColumnPropNameInTable="AddressColumn" msprop:Generator_UserColumnName="Address">
1995 <xs:simpleType>
1996 <xs:restriction base="xs:string">
1997 <xs:maxLength value="250" />
1998 </xs:restriction>
1999 </xs:simpleType>
2000 </xs:element>
2001 <xs:element name="City" msprop:Generator_ColumnVarNameInTable="columnCity" msprop:Generator_ColumnPropNameInRow="City" msprop:Generator_ColumnPropNameInTable="CityColumn" msprop:Generator_UserColumnName="City">
2002 <xs:simpleType>
2003 <xs:restriction base="xs:string">
2004 <xs:maxLength value="200" />
2005 </xs:restriction>
2006 </xs:simpleType>
2007 </xs:element>
2008 <xs:element name="State" msprop:Generator_ColumnVarNameInTable="columnState" msprop:Generator_ColumnPropNameInRow="State" msprop:Generator_ColumnPropNameInTable="StateColumn" msprop:Generator_UserColumnName="State">
2009 <xs:simpleType>
2010 <xs:restriction base="xs:string">
2011 <xs:maxLength value="150" />
2012 </xs:restriction>
2013 </xs:simpleType>
2014 </xs:element>
2015 <xs:element name="ZipCode" msprop:Generator_ColumnVarNameInTable="columnZipCode" msprop:Generator_ColumnPropNameInRow="ZipCode" msprop:Generator_ColumnPropNameInTable="ZipCodeColumn" msprop:Generator_UserColumnName="ZipCode" minOccurs="0">
2016 <xs:simpleType>
2017 <xs:restriction base="xs:string">
2018 <xs:maxLength value="15" />
2019 </xs:restriction>
2020 </xs:simpleType>
2021 </xs:element>
2022 <xs:element name="ContactNo" msprop:Generator_ColumnVarNameInTable="columnContactNo" msprop:Generator_ColumnPropNameInRow="ContactNo" msprop:Generator_ColumnPropNameInTable="ContactNoColumn" msprop:Generator_UserColumnName="ContactNo">
2023 <xs:simpleType>
2024 <xs:restriction base="xs:string">
2025 <xs:maxLength value="150" />
2026 </xs:restriction>
2027 </xs:simpleType>
2028 </xs:element>
2029 <xs:element name="EmailID" msprop:Generator_ColumnVarNameInTable="columnEmailID" msprop:Generator_ColumnPropNameInRow="EmailID" msprop:Generator_ColumnPropNameInTable="EmailIDColumn" msprop:Generator_UserColumnName="EmailID" minOccurs="0">
2030 <xs:simpleType>
2031 <xs:restriction base="xs:string">
2032 <xs:maxLength value="200" />
2033 </xs:restriction>
2034 </xs:simpleType>
2035 </xs:element>
2036 <xs:element name="Remarks" msprop:Generator_ColumnVarNameInTable="columnRemarks" msprop:Generator_ColumnPropNameInRow="Remarks" msprop:Generator_ColumnPropNameInTable="RemarksColumn" msprop:Generator_UserColumnName="Remarks" minOccurs="0">
2037 <xs:simpleType>
2038 <xs:restriction base="xs:string">
2039 <xs:maxLength value="2147483647" />
2040 </xs:restriction>
2041 </xs:simpleType>
2042 </xs:element>
2043 </xs:sequence>
2044 </xs:complexType>
2045 </xs:element>
2046 <xs:element name="Temp_Stock" msprop:Generator_TableClassName="Temp_StockDataTable" msprop:Generator_TableVarName="tableTemp_Stock" msprop:Generator_TablePropName="Temp_Stock" msprop:Generator_RowDeletingName="Temp_StockRowDeleting" msprop:Generator_RowChangingName="Temp_StockRowChanging" msprop:Generator_RowEvHandlerName="Temp_StockRowChangeEventHandler" msprop:Generator_RowDeletedName="Temp_StockRowDeleted" msprop:Generator_UserTableName="Temp_Stock" msprop:Generator_RowChangedName="Temp_StockRowChanged" msprop:Generator_RowEvArgName="Temp_StockRowChangeEvent" msprop:Generator_RowClassName="Temp_StockRow">
2047 <xs:complexType>
2048 <xs:sequence>
2049 <xs:element name="ProductID" msprop:Generator_ColumnVarNameInTable="columnProductID" msprop:Generator_ColumnPropNameInRow="ProductID" msprop:Generator_ColumnPropNameInTable="ProductIDColumn" msprop:Generator_UserColumnName="ProductID" type="xs:int" />
2050 <xs:element name="Qty" msprop:Generator_ColumnVarNameInTable="columnQty" msprop:Generator_ColumnPropNameInRow="Qty" msprop:Generator_ColumnPropNameInTable="QtyColumn" msprop:Generator_UserColumnName="Qty" type="xs:int" />
2051 </xs:sequence>
2052 </xs:complexType>
2053 </xs:element>
2054 </xs:choice>
2055 </xs:complexType>
2056 <xs:unique name="Constraint1" msdata:PrimaryKey="true">
2057 <xs:selector xpath=".//mstns:Activation" />
2058 <xs:field xpath="mstns:ID" />
2059 </xs:unique>
2060 <xs:unique name="Category_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
2061 <xs:selector xpath=".//mstns:Category" />
2062 <xs:field xpath="mstns:CategoryName" />
2063 </xs:unique>
2064 <xs:unique name="Company_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
2065 <xs:selector xpath=".//mstns:Company" />
2066 <xs:field xpath="mstns:ID" />
2067 </xs:unique>
2068 <xs:unique name="Company_Contacts_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
2069 <xs:selector xpath=".//mstns:Company_Contacts" />
2070 <xs:field xpath="mstns:Id" />
2071 </xs:unique>
2072 <xs:unique name="Customer_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
2073 <xs:selector xpath=".//mstns:Customer" />
2074 <xs:field xpath="mstns:ID" />
2075 </xs:unique>
2076 <xs:unique name="Invoice_Payment_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
2077 <xs:selector xpath=".//mstns:Invoice_Payment" />
2078 <xs:field xpath="mstns:IP_ID" />
2079 </xs:unique>
2080 <xs:unique name="Invoice_Product_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
2081 <xs:selector xpath=".//mstns:Invoice_Product" />
2082 <xs:field xpath="mstns:IPo_ID" />
2083 </xs:unique>
2084 <xs:unique name="InvoiceInfo_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
2085 <xs:selector xpath=".//mstns:InvoiceInfo" />
2086 <xs:field xpath="mstns:Inv_ID" />
2087 </xs:unique>
2088 <xs:unique name="Logs_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
2089 <xs:selector xpath=".//mstns:Logs" />
2090 <xs:field xpath="mstns:ID" />
2091 </xs:unique>
2092 <xs:unique name="Product_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
2093 <xs:selector xpath=".//mstns:Product" />
2094 <xs:field xpath="mstns:PID" />
2095 </xs:unique>
2096 <xs:unique name="Product_Join_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
2097 <xs:selector xpath=".//mstns:Product_Join" />
2098 <xs:field xpath="mstns:Id" />
2099 </xs:unique>
2100 <xs:unique name="Quotation_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
2101 <xs:selector xpath=".//mstns:Quotation" />
2102 <xs:field xpath="mstns:Q_ID" />
2103 </xs:unique>
2104 <xs:unique name="Quotation_Join_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
2105 <xs:selector xpath=".//mstns:Quotation_Join" />
2106 <xs:field xpath="mstns:QJ_ID" />
2107 </xs:unique>
2108 <xs:unique name="Registration_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
2109 <xs:selector xpath=".//mstns:Registration" />
2110 <xs:field xpath="mstns:UserID" />
2111 </xs:unique>
2112 <xs:unique name="Service_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
2113 <xs:selector xpath=".//mstns:Service" />
2114 <xs:field xpath="mstns:S_ID" />
2115 </xs:unique>
2116 <xs:unique name="Stock_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
2117 <xs:selector xpath=".//mstns:Stock" />
2118 <xs:field xpath="mstns:ST_ID" />
2119 </xs:unique>
2120 <xs:unique name="Stock_Product_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
2121 <xs:selector xpath=".//mstns:Stock_Product" />
2122 <xs:field xpath="mstns:SP_ID" />
2123 </xs:unique>
2124 <xs:unique name="SubCategory_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
2125 <xs:selector xpath=".//mstns:SubCategory" />
2126 <xs:field xpath="mstns:ID" />
2127 </xs:unique>
2128 <xs:unique name="Supplier_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
2129 <xs:selector xpath=".//mstns:Supplier" />
2130 <xs:field xpath="mstns:ID" />
2131 </xs:unique>
2132 <xs:unique name="Temp_Stock_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
2133 <xs:selector xpath=".//mstns:Temp_Stock" />
2134 <xs:field xpath="mstns:ProductID" />
2135 </xs:unique>
2136 </xs:element>
2137 <xs:annotation>
2138 <xs:appinfo>
2139 <msdata:Relationship name="FK_Invoice_Payment_InvoiceInfo" msdata:parent="InvoiceInfo" msdata:child="Invoice_Payment" msdata:parentkey="Inv_ID" msdata:childkey="InvoiceID" msprop:Generator_UserChildTable="Invoice_Payment" msprop:Generator_ChildPropName="GetInvoice_PaymentRows" msprop:Generator_UserRelationName="FK_Invoice_Payment_InvoiceInfo" msprop:Generator_RelationVarName="relationFK_Invoice_Payment_InvoiceInfo" msprop:Generator_UserParentTable="InvoiceInfo" msprop:Generator_ParentPropName="InvoiceInfoRow" />
2140 <msdata:Relationship name="FK_Invoice_Product_InvoiceInfo" msdata:parent="InvoiceInfo" msdata:child="Invoice_Product" msdata:parentkey="Inv_ID" msdata:childkey="InvoiceID" msprop:Generator_UserChildTable="Invoice_Product" msprop:Generator_ChildPropName="GetInvoice_ProductRows" msprop:Generator_UserRelationName="FK_Invoice_Product_InvoiceInfo" msprop:Generator_RelationVarName="relationFK_Invoice_Product_InvoiceInfo" msprop:Generator_UserParentTable="InvoiceInfo" msprop:Generator_ParentPropName="InvoiceInfoRow" />
2141 <msdata:Relationship name="FK_Invoice_Product_Product" msdata:parent="Product" msdata:child="Invoice_Product" msdata:parentkey="PID" msdata:childkey="ProductID" msprop:Generator_UserChildTable="Invoice_Product" msprop:Generator_ChildPropName="GetInvoice_ProductRows" msprop:Generator_UserRelationName="FK_Invoice_Product_Product" msprop:Generator_RelationVarName="relationFK_Invoice_Product_Product" msprop:Generator_UserParentTable="Product" msprop:Generator_ParentPropName="ProductRow" />
2142 <msdata:Relationship name="FK_InvoiceInfo_Customer" msdata:parent="Customer" msdata:child="InvoiceInfo" msdata:parentkey="ID" msdata:childkey="CustomerID" msprop:Generator_UserChildTable="InvoiceInfo" msprop:Generator_ChildPropName="GetInvoiceInfoRows" msprop:Generator_UserRelationName="FK_InvoiceInfo_Customer" msprop:Generator_ParentPropName="CustomerRow" msprop:Generator_RelationVarName="relationFK_InvoiceInfo_Customer" msprop:Generator_UserParentTable="Customer" />
2143 <msdata:Relationship name="FK_Logs_Registration" msdata:parent="Registration" msdata:child="Logs" msdata:parentkey="UserID" msdata:childkey="UserID" msprop:Generator_UserChildTable="Logs" msprop:Generator_ChildPropName="GetLogsRows" msprop:Generator_UserRelationName="FK_Logs_Registration" msprop:Generator_RelationVarName="relationFK_Logs_Registration" msprop:Generator_UserParentTable="Registration" msprop:Generator_ParentPropName="RegistrationRow" />
2144 <msdata:Relationship name="FK_Product_SubCategory" msdata:parent="SubCategory" msdata:child="Product" msdata:parentkey="ID" msdata:childkey="SubCategoryID" msprop:Generator_UserChildTable="Product" msprop:Generator_ChildPropName="GetProductRows" msprop:Generator_UserRelationName="FK_Product_SubCategory" msprop:Generator_RelationVarName="relationFK_Product_SubCategory" msprop:Generator_UserParentTable="SubCategory" msprop:Generator_ParentPropName="SubCategoryRow" />
2145 <msdata:Relationship name="FK_Product_Join_Product" msdata:parent="Product" msdata:child="Product_Join" msdata:parentkey="PID" msdata:childkey="ProductID" msprop:Generator_UserChildTable="Product_Join" msprop:Generator_ChildPropName="GetProduct_JoinRows" msprop:Generator_UserRelationName="FK_Product_Join_Product" msprop:Generator_ParentPropName="ProductRow" msprop:Generator_RelationVarName="relationFK_Product_Join_Product" msprop:Generator_UserParentTable="Product" />
2146 <msdata:Relationship name="FK_Quotation_Customer" msdata:parent="Customer" msdata:child="Quotation" msdata:parentkey="ID" msdata:childkey="CustomerID" msprop:Generator_UserChildTable="Quotation" msprop:Generator_ChildPropName="GetQuotationRows" msprop:Generator_UserRelationName="FK_Quotation_Customer" msprop:Generator_ParentPropName="CustomerRow" msprop:Generator_RelationVarName="relationFK_Quotation_Customer" msprop:Generator_UserParentTable="Customer" />
2147 <msdata:Relationship name="FK_Quotation_Join_Product" msdata:parent="Product" msdata:child="Quotation_Join" msdata:parentkey="PID" msdata:childkey="ProductID" msprop:Generator_UserChildTable="Quotation_Join" msprop:Generator_ChildPropName="GetQuotation_JoinRows" msprop:Generator_UserRelationName="FK_Quotation_Join_Product" msprop:Generator_ParentPropName="ProductRow" msprop:Generator_RelationVarName="relationFK_Quotation_Join_Product" msprop:Generator_UserParentTable="Product" />
2148 <msdata:Relationship name="FK_Quotation_Join_Quotation" msdata:parent="Quotation" msdata:child="Quotation_Join" msdata:parentkey="Q_ID" msdata:childkey="QuotationID" msprop:Generator_UserChildTable="Quotation_Join" msprop:Generator_ChildPropName="GetQuotation_JoinRows" msprop:Generator_UserRelationName="FK_Quotation_Join_Quotation" msprop:Generator_ParentPropName="QuotationRow" msprop:Generator_RelationVarName="relationFK_Quotation_Join_Quotation" msprop:Generator_UserParentTable="Quotation" />
2149 <msdata:Relationship name="FK_Service_Customer" msdata:parent="Customer" msdata:child="Service" msdata:parentkey="ID" msdata:childkey="CustomerID" msprop:Generator_UserChildTable="Service" msprop:Generator_ChildPropName="GetServiceRows" msprop:Generator_UserRelationName="FK_Service_Customer" msprop:Generator_ParentPropName="CustomerRow" msprop:Generator_RelationVarName="relationFK_Service_Customer" msprop:Generator_UserParentTable="Customer" />
2150 <msdata:Relationship name="FK_Stock_Supplier" msdata:parent="Supplier" msdata:child="Stock" msdata:parentkey="ID" msdata:childkey="SupplierID" msprop:Generator_UserChildTable="Stock" msprop:Generator_ChildPropName="GetStockRows" msprop:Generator_UserRelationName="FK_Stock_Supplier" msprop:Generator_RelationVarName="relationFK_Stock_Supplier" msprop:Generator_UserParentTable="Supplier" msprop:Generator_ParentPropName="SupplierRow" />
2151 <msdata:Relationship name="FK_Stock_Product_Product" msdata:parent="Product" msdata:child="Stock_Product" msdata:parentkey="PID" msdata:childkey="ProductID" msprop:Generator_UserChildTable="Stock_Product" msprop:Generator_ChildPropName="GetStock_ProductRows" msprop:Generator_UserRelationName="FK_Stock_Product_Product" msprop:Generator_ParentPropName="ProductRow" msprop:Generator_RelationVarName="relationFK_Stock_Product_Product" msprop:Generator_UserParentTable="Product" />
2152 <msdata:Relationship name="FK_Stock_Product_Stock" msdata:parent="Stock" msdata:child="Stock_Product" msdata:parentkey="ST_ID" msdata:childkey="StockID" msprop:Generator_UserChildTable="Stock_Product" msprop:Generator_ChildPropName="GetStock_ProductRows" msprop:Generator_UserRelationName="FK_Stock_Product_Stock" msprop:Generator_ParentPropName="StockRow" msprop:Generator_RelationVarName="relationFK_Stock_Product_Stock" msprop:Generator_UserParentTable="Stock" />
2153 <msdata:Relationship name="FK_SubCategory_Category" msdata:parent="Category" msdata:child="SubCategory" msdata:parentkey="CategoryName" msdata:childkey="Category" msprop:Generator_UserChildTable="SubCategory" msprop:Generator_ChildPropName="GetSubCategoryRows" msprop:Generator_UserRelationName="FK_SubCategory_Category" msprop:Generator_ParentPropName="CategoryRow" msprop:Generator_RelationVarName="relationFK_SubCategory_Category" msprop:Generator_UserParentTable="Category" />
2154 <msdata:Relationship name="FK_Temp_Stock_Product" msdata:parent="Product" msdata:child="Temp_Stock" msdata:parentkey="PID" msdata:childkey="ProductID" msprop:Generator_UserChildTable="Temp_Stock" msprop:Generator_ChildPropName="GetTemp_StockRows" msprop:Generator_UserRelationName="FK_Temp_Stock_Product" msprop:Generator_ParentPropName="ProductRow" msprop:Generator_RelationVarName="relationFK_Temp_Stock_Product" msprop:Generator_UserParentTable="Product" />
2155 </xs:appinfo>
2156 </xs:annotation>
2157 </xs:schema>